MikeKlausing
6 years agoQrew Assistant Captain
Insert $ symbol in front of rich text formula
I have a rich text formula that is putting 10 numbers in a vertical list with the following formula:
"<span style=\"font-size:11px;\">" &
"<b>" &
(List
("<br />",
ToText(([Minimum Record ID# Windows - Window Subtotal])),
ToText([Minimum Record ID# 2nd windws - Window Subtotal]),
ToText([Minimum Record ID# 3rd windows - Window Subtotal]),
ToText([Minimum Record ID# 4th windows - Window Subtotal]),
ToText([Minimum Record ID# 5th windows - Window Subtotal]),
ToText([Minimum Record ID# 6th windows - Window Subtotal]),
ToText([Minimum Record ID# 7th windows - Window Subtotal]),
ToText([Minimum Record ID# 8th windows - Window Subtotal]),
ToText([Minimum Record ID# 9th windows - Window Subtotal]),
ToText([Minimum Record ID# 10th windows - Window Subtotal])))
& "</b>"
& "</span>"
Is there a way to make these numbers display a dollar sign in front of them if they are >0 or if there are values in those fields?
------------------------------
Mike Klausing
------------------------------
"<span style=\"font-size:11px;\">" &
"<b>" &
(List
("<br />",
ToText(([Minimum Record ID# Windows - Window Subtotal])),
ToText([Minimum Record ID# 2nd windws - Window Subtotal]),
ToText([Minimum Record ID# 3rd windows - Window Subtotal]),
ToText([Minimum Record ID# 4th windows - Window Subtotal]),
ToText([Minimum Record ID# 5th windows - Window Subtotal]),
ToText([Minimum Record ID# 6th windows - Window Subtotal]),
ToText([Minimum Record ID# 7th windows - Window Subtotal]),
ToText([Minimum Record ID# 8th windows - Window Subtotal]),
ToText([Minimum Record ID# 9th windows - Window Subtotal]),
ToText([Minimum Record ID# 10th windows - Window Subtotal])))
& "</b>"
& "</span>"
Is there a way to make these numbers display a dollar sign in front of them if they are >0 or if there are values in those fields?
------------------------------
Mike Klausing
------------------------------