Adding $ symbol within formula

Question

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 anybody and everybody.

------------------------------
Michael Brumfield
------------------------------

markshnier__you · Answer

I'm not understanding the question.if you want to make a string read ($)&nbsp;the formula would be"($)"But what is your full question?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

mike · Answer

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
------------------------------

markshnier__you · Answer

Rather 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
------------------------------

mike · Answer

Here ya go, Mark -- and thank you so much. &nbsp;It's the "per" where I would like to have a $ in front of the number, as in ("&amp; [Island DF per]&amp;")...."&lt;b&gt;&lt;font size=2 color=darkblue&gt;"&amp;[ROOM]&amp;" &lt;/font&gt;"&amp;[ROOM NOTES]&amp;"&lt;br&gt;&lt;/b&gt;"&amp;List("
&lt;br&gt;",If([ISLAND],"&lt;b&gt;ISLAND&lt;/b&gt;"&amp;"&lt;br&gt;&amp;nbsp;&amp;nbsp;DRAWER FRONTS: ("&amp; [Island DF #]&amp;") ("&amp; [Island DF per]&amp;") $"&amp;[Island DF Total]&amp;".00 " &amp; If([Island DF Included]=true,"&lt;font color=red&gt;NOT INCLUDED &lt;/font&gt; ","")&amp; "&lt;br&gt;&amp;nbsp;&amp;nbsp;CABINET FACES: ("&amp; [Island CF #]&amp;") ("&amp; [Island CF per]&amp;") $"&amp;[Island CF total]&amp;".00 " &amp; If([Island CF included]=true,"&lt;font color=red&gt;NOT INCLUDED &lt;/font&gt; ","")&amp; "&lt;br&gt;&amp;nbsp;&amp;nbsp; &lt;font color=darkgreen&gt;NOTES:&lt;/font&gt; "&amp;[Island Notes]&amp;" ",null),If([REFRIGERATOR AREA],"&lt;b&gt;REFRIGERATOR AREA&lt;/b&gt;"&amp;"&lt;br&gt;&amp;nbsp;&amp;nbsp;DRAWER FRONTS: ("&amp; [Fridge DF#]&amp;") ("&amp; [Fridge DF per]&amp;") $"&amp;[Fridge DF TOT]&amp;".00 " &amp; If([FRIDGE DF INCLUDED]=true,"&lt;font color=red&gt;NOT INCLUDED &lt;/font&gt; ","")&amp; "&lt;br&gt;&amp;nbsp;&amp;nbsp;CABINET FACES: ("&amp; [Fridge CF#]&amp;") ("&amp; [Fridge CF per]&amp;") $"&amp;[Fridge CF TOT]&amp;".00 " &amp; If([FRIDGE CF INCLUDED]=true,"&lt;font color=red&gt;NOT INCLUDED &lt;/font&gt; ","")&amp; "&lt;br&gt;&amp;nbsp;&amp;nbsp; &lt;font color=darkgreen&gt;NOTES:&lt;/font&gt; "&amp;[Fridge Notes]&amp;" ",null),"____________________________","&lt;b&gt;LABOR: $"&amp;[Amount ($) CABINETS]&amp;".00")------------------------------Michael Brumfield------------------------------

markshnier__you · Answer

try this($"&amp; [Island DF per]&amp;")------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Adding $ symbol within formula

9 Replies

Related Content

Formula checkbox using manual checkbox and lookup formula

Symbols added to automated emails

Conditional formula url

Format Formula URL field

Year Formula help

Recent Discussions

View query record if single record otherwise view query list

How do I unhide an app that I have no idea what it is named?

Gnatt plugin

Justifications for Table Report Columns

Quickbase JMP connection