Knowledge Drop

Scientific notation with n significant figures in table calc

Userlevel 3

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})))


Screen Shot 2018-10-25 at 1.13.21 PM.png


This content is subject to limited support.                




0 replies

Be the first to reply!