AshleySolomon

2 years agoQrew Trainee

Solved

# Formula - Rich Text field is not displaying zeros after the "."

I have a Formula - Rich Text field that is converting a Currency field "ToText". The value was Rounding the "cents" up to the nearest dollar value which I have solved for. However, now I can't get 0s after the decimal to display.

I tried applying Abs (absolute value) but that didn't resolve the issue. Below is my formula...HELP!

If(ToText([COR Amount])<>"", "$"&ToFormattedText(Round([COR Amount],0.01),"comma_dot"))

------------------------------

Ashley Solomon

------------------------------

I tried applying Abs (absolute value) but that didn't resolve the issue. Below is my formula...HELP!

If(ToText([COR Amount])<>"", "$"&ToFormattedText(Round([COR Amount],0.01),"comma_dot"))

------------------------------

Ashley Solomon

------------------------------

- Here are my notes to convert currency. I think this was courtesy of Your QuickBase Coach.

var number Currency = [Currency Field] ;

var text FormattedNumber =

"$" &

ToFormattedText($Currency,"comma_dot",3) &

If(

not Contains(ToText($Currency),"."), ".00",

Length(Right(ToText($Currency),"."))=1,"0"

);

$FormattedNumber

------------------------------

Mike Tamoush

------------------------------