55291_en-US

liliconcom

Decimal Format Problem

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

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.

Re: Decimal Format Problem

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!!