Forum Discussion

AshleySolomon's avatar
AshleySolomon
Qrew Trainee
2 years ago
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
------------------------------
  • MikeTamoush's avatar
    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
    ------------------------------

2 Replies

Sort By
  • MikeTamoush's avatar
    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's avatar
      AshleySolomon
      Qrew Trainee
      2 years ago
      Your formula was the solution. Much appreciated Mike.

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