Skip to main content
Question

Add decimals to the right of a text field

  • Jan 23, 2020 8:36 PM UTC
  • 0 replies
  • 101 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.

  • Qrew Member
  • Jan 24, 2020 8:23 PM UTC
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
------------------------------