I can't figure how to solve this,
I have a report calculation field that I want conditional decimal places on, for example if the calculation results in the last digit as being anything other than a zero, say $4.325 to show with all three decimal places ...i.e. $4.325 , BUT if the calculation results in a number like $3.920 (a zero on the end) ...I just want it to show on the report as $3.92
How do I approach this?
I have a report calculation field that I want conditional decimal places on, for example if the calculation results in the last digit as being anything other than a zero, say $4.325 to show with all three decimal places ...i.e. $4.325 , BUT if the calculation results in a number like $3.920 (a zero on the end) ...I just want it to show on the report as $3.92
How do I approach this?
Show only 2 decimal places *IF* the last digit is a zero?
