Forum Discussion

Mike's avatar
Mike
Qrew Member
4 years ago

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

------------------------------
Michael Brumfield
------------------------------
  • I'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
    ------------------------------
    • Mike's avatar
      Mike
      Qrew Member
      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's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        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
        ------------------------------