AnsweredAssumed Answered

Use a formula to remove 2dp from a 2dp formatted cell

Question asked by Stu412 on Oct 5, 2016
Latest reply on Oct 5, 2016 by Mike_Mitchell

I have a situation where I have a field calculating a value and depending on the record I need this value to be either 0 decimal places or 2 decimal places.

 

See below - How can I have Codes 1000 and 1010 reported to 2DP and code 1020 report to 0DP in the same field?

 

The data set is pretty simple, as follows:

 

Code     Description           Value

1000     Blue Things          10.00

1010     Red Things           25.00

1020     Months in range     6

 

So when I report on this I'd get:

 

Blue things     10.00

Red things      25.00

Months           6

 

However, because of the on report formatting (inspector) of the field, I get this:

 

Blue things     10.00

Red things      25.00

Months           6.00

 

6.00 months is not sensible for the report I'm writing and I don't want to write a second field which would be returning only Code 1020 and then format that to 0 decimal places.

 

I've tried to use truncate and this removes other decimals I have, but replaces them with zeros (I'd guess because of the field on report formatting from the inspector).

 

 

 

Thanks

Outcomes