ITE - if use math column, it does not keep the precision decimal places

Issue:

  • create a math column for time calc - all good
    — precision = 1 (no decimals)

  • then create ITE that includes the math column
    — ah, I see what’s happening, you lose the precision and I get lots of decimal places
    – unexpected!!

:frowning:

and what it looks like to the end user…

1 Like

I work around this problem by using a “Template columns” for displaying calculated values

but I approve of this bug ticket.

1 Like

I guess it depends, but I feel it’s expected behavior. Precision is only cosmetic and only for that specific column for display purposes. If you start using the column elsewhere, for other math or what not, it’s going to use the underlying value instead of the value with precision/units applied. Template columns are a way to “lock in” that value, but otherwise I usually expect the underlying value to be used instead of the surface formatted value. If you want a true rounded value where it’s rounded on the surface and the underlying value is also rounded, then your Math column should use the Round() function.

2 Likes

That’s a good point. More of an expert tip as it is not documented in an easily accessible way.

Speaking of which, is there a list of operators we can use for the math colmns?

1 Like

No :stuck_out_tongue:

2 Likes

I always wondered if such a list existed… I guess next time I should just google it :wink: thanks!

1 Like