ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Convert number to standard form

fallon1
6 - Meteoroid

I need to change numbers to be in standard form of 7 s.f.

 

e.g. from 2931131555743 to 2.931132E+12.

 

I can leave the final value as a string however it needs to match the above format exactly. My current thought process is to round it to 2931132000000 then strip it apart as a string however this will cause problems if the number before the E is rounded to 0, is there another way to do it?

 

 

Thanks

afv2688
16 - Nebula
16 - Nebula

Hello @fallon1,

 

try using this

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

afv2688
16 - Nebula
16 - Nebula

Hello @fallon1,

 

added the function for values >1 now:

 

Untitled.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

Labels