Report Designer - Formatting formulas to 2 decimals

Hello,

Try casting the field with CDbl or CDec, like

Cdbl([POOrder.CuryLineTotal])

Laura

Hi @DeniseNeil89 

Please try the format below:

Best Regards,

NNT

Using ###,##0.#0 allows the field to place as many numbers before the last zero as it wants to. 

Using ###,##0.00 should work, as well as what the others have suggested as well.

Thank you for all the responses. I’ve tried them all and I’m still seeing 4 decimal places for both the PO Total & Total CAD.  There is a formula in the Tax Total but it’s never had an issue.

Any other suggestions?

Hi @DeniseNeil89 

Please attach the .rpx file of the report.

Best Regards,

NNT

Hi @DeniseNeil89,

You can format the field in the properties of Appearance section.  You can use $ ###,##0.00 or “C” in the Format section.

Hope, it helps!

Thanks Lanaswillow!

I just needed to remove the ‘$’ + from the formula as c2 will bring in the correct formatting.

Hello Denise,

Try:

• Changing the format to c2

 

• Lastly remove the ‘$’ + from your formula as c2 will bring in the correct formatting

 

Thanks ​@Lanaswillow, your tip on removing ‘$’ in the value box also helped me. 

I however had to use  “$ ###,##0.00” instead of ‘c’ because my Report Designer kept returning ‘£’ instead of ‘$’ when using ‘c’.