Skip to main content
Question

How to stop StatisticsCalculator from converting a summed value to scientific format?


johnk
Contributor
Forum|alt.badge.img+4
  • Contributor

I'm trying to sum a series of values by an ID in the StatisticsCalculator (using the group by function) and the summed values keep returning as scientific format (5.9e-6) but I want the decimal number (0.00000599).

How do I do this?

P.s it only seems to happen when I set to group by.

4 replies

redgeographics
Celebrity
Forum|alt.badge.img+58

It's not just the StatisticsCalculator, any number field apparently.

 

One workaround would be to use the StringFormatter afterwards and use the format string f to force it to a floating point number.

Schermafbeelding 2022-07-14 092955


redgeographics
Celebrity
Forum|alt.badge.img+58
redgeographics wrote:

It's not just the StatisticsCalculator, any number field apparently.

 

One workaround would be to use the StringFormatter afterwards and use the format string f to force it to a floating point number.

Schermafbeelding 2022-07-14 092955

I wonder how long this has been in there, I've gone back to the oldest build I have installed, 20614, and it's happening there too. Only with small numbers though, 1e-5 and smaller.


johnk
Contributor
Forum|alt.badge.img+4
  • Author
  • Contributor
  • July 14, 2022
redgeographics wrote:

It's not just the StatisticsCalculator, any number field apparently.

 

One workaround would be to use the StringFormatter afterwards and use the format string f to force it to a floating point number.

Schermafbeelding 2022-07-14 092955

Hi @Hans van der Maarel​, thanks for the reply! I tried this first and whilst it works for some values, it doesn't for all


redgeographics
Celebrity
Forum|alt.badge.img+58
johnk wrote:

Hi @Hans van der Maarel​, thanks for the reply! I tried this first and whilst it works for some values, it doesn't for all

Which values does it not work for?


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings