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
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.