topic Decimal Format Problem in Discussions

Decimal Format Problem

Aam_jmp — Fri, 20 Apr 2018 13:01:39 GMT

I have columns where I want to limit the decimal places to 2. Example, 0.335256 should be 0.34. I am using dt:ColumnName << Format( "Fixed Dec", 12, 2 ); and it works perfectly. However, some cells in the columns have values like: <0.00234 for which this Format outputs 0.00, whereas I want <0.00. How can I achieve this? Thank you.

Re: Decimal Format Problem

Aam_jmp — Fri, 20 Apr 2018 13:29:48 GMT

Never mind, I figured I can use PValue to achieve what I wanted. So, the format is : dt:ColumnName << Format( "PValue", 6 ); I still cannot limit it to 2 decimals though!!

Re: Decimal Format Problem

Jeff_Perkinson — Fri, 20 Apr 2018 14:27:52 GMT

You can use a Custom Format to get what you want.

In the Column Info window choose Format->Custom.

Then click the Set Custom Format format button.

You'll end up in a version of the Formula Editor which will allow you to reformat the value as you wish.

Ultimately it would look something like this.