I need to format a currency field. I'm hoping someone can help me craft decimal and rounding formulas within a custom numeric style.
I always need at least two decimal places displayed =
Database Value Report Display
35 35.00
35.5 35.50
35.032 35.023
35.3694 35.3694
.0045 .0045
I've looked through a bunch of other posts, but all the code samples I located drop trailing zeros. Standard formatting of the field doesn't work either since that displays trailing zeros like 35.0000.
If anyone has any ideas I'd be greatful.
Thank you!
I always need at least two decimal places displayed =
Database Value Report Display
35 35.00
35.5 35.50
35.032 35.023
35.3694 35.3694
.0045 .0045
I've looked through a bunch of other posts, but all the code samples I located drop trailing zeros. Standard formatting of the field doesn't work either since that displays trailing zeros like 35.0000.
If anyone has any ideas I'd be greatful.
Thank you!