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 ...

MikeTamoush
2 years ago
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
------------------------------

MikeTamoush

Qrew Commander

2 years ago

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
------------------------------

AshleySolomon
Qrew Trainee
2 years ago
Your formula was the solution. Much appreciated Mike.

------------------------------
Ashley Solomon
------------------------------

Forum Discussion

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