Scientific notation with n significant figures in table calc

[chris_seymour1]

Knowledge Drop

Last tested: Oct 25, 2018
 

You can replace n with the number of sig figs in this formula:

concat(round(${view_name.field_name}/power(10, floor(log(${view_name.field_name}))), n-1), " x 10^", floor(log(${view_name.field_name})))

Example with n=2:

concat(round(${orders.count}/power(10, floor(log(${orders.count}))), 1), " x 10^", floor(log(${orders.count})))

This content is subject to limited support.