Skip to main content
Question

Add decimals to the right of a text field

  • January 23, 2020
  • 0 replies
  • 49 views
I have a formula converting numbers to a list of text. I need it to display a list of amounts vertically. Everything is working properly including the "$" out front. The last thing I am needing to place is ".00" at the end of each of these fields to show the decimal places. 

"<span style=\"font-size:11px;\">" &
"<b>" &
"<span style=\"text-decoration:underline;\">" &
"<p style=\"text-align: Right;\">" &


var text VerticalList =
(List
(" <br />",
ToText([Cost Notes]),
ToText([Note 2 Cost]),
ToText([Note 3 Cost]),
ToText([Note 4 Cost])));

If($VerticalList <> "",
"$"
& $VerticalList)


&"</p>"
& "</span>"
& "</b>"
& "</span>"

------------------------------
Mike Klausing
------------------------------
This topic has been closed for replies.

  • LisaSell1
  • Registered
  • January 24, 2020
Hi Mike, I tried your formula in a Rich Text field. All you need to update is this:

ToText([Cost Notes]) &".00",
ToText([Note 2 Cost]) &".00",
ToText([Note 3 Cost]) &".00",
ToText([Note 4 Cost]) &".00"));


------------------------------
Lisa Sell
------------------------------
Terms & ConditionsAccessibility statement