Skip to main content
Solved

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

  • February 8, 2023
  • 0 replies
  • 294 views
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
------------------------------

Best answer by MikeTamoush

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

      Forum|alt.badge.img+20
      • MikeTamoush
      • Registered
      • Answer
      • February 8, 2023
      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
      ------------------------------
        Forum|alt.badge.img+3
        • cpansewicz
        • Registered
        • February 19, 2025

        This formula works great for me. I have an odd issue where all of the values were formatted correctly, except one value was rounded up. Very weird.

        Terms & ConditionsAccessibility statement