Adding $ symbol within formula
I have a rich formula field that contains this: ("& [Island DF per]&") which gives me () and I'm trying to figure out how to have it read ($), but I just can't figure out where to put the $. Thanks...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI'm not understanding the question.
if you want to make a string read ($)
the formula would be
"($)"
But what is your full question?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
if you want to make a string read ($)
the formula would be
"($)"
But what is your full question?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Here's a screenshot of the formula with the part you suggest in it -- I have two multiple choice fields, a how many and a cost per item. So I would like it to read:
Item: (5) ($10) = $50 but right now it reads:
Item: (5) (10) = $50
------------------------------
Michael Brumfield
------------------------------
Item: (5) ($10) = $50 but right now it reads:
Item: (5) (10) = $50
------------------------------
Michael Brumfield
------------------------------
- MarkShnier__YouRather than a screenshot, can you copy and paste your actual code so I can edit it?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Here ya go, Mark -- and thank you so much. It's the "per" where I would like to have a $ in front of the number, as in ("& [Island DF per]&")....
"<b><font size=2 color=darkblue>"&[ROOM]&" </font>"&[ROOM NOTES]&"<br></b>"&
List("\n<br>",
If([ISLAND],"<b>ISLAND</b>"&"<br> DRAWER FRONTS: ("& [Island DF #]&") ("& [Island DF per]&") $"&[Island DF Total]&".00 " & If([Island DF Included]=true,"<font color=red>NOT INCLUDED </font> ","")& "<br> CABINET FACES: ("& [Island CF #]&") ("& [Island CF per]&") $"&[Island CF total]&".00 " & If([Island CF included]=true,"<font color=red>NOT INCLUDED </font> ","")& "<br> <font color=darkgreen>NOTES:</font> "&[Island Notes]&" ",null),
If([REFRIGERATOR AREA],"<b>REFRIGERATOR AREA</b>"&"<br> DRAWER FRONTS: ("& [Fridge DF#]&") ("& [Fridge DF per]&") $"&[Fridge DF TOT]&".00 " & If([FRIDGE DF INCLUDED]=true,"<font color=red>NOT INCLUDED </font> ","")& "<br> CABINET FACES: ("& [Fridge CF#]&") ("& [Fridge CF per]&") $"&[Fridge CF TOT]&".00 " & If([FRIDGE CF INCLUDED]=true,"<font color=red>NOT INCLUDED </font> ","")& "<br> <font color=darkgreen>NOTES:</font> "&[Fridge Notes]&" ",null),
"____________________________",
"<b>LABOR: $"&[Amount ($) CABINETS]&".00")
------------------------------
Michael Brumfield
------------------------------- MarkShnier__Youtry this
($"& [Island DF per]&")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
