Forum Discussion

JeffRogerson's avatar
JeffRogerson
Qrew Cadet
11 years ago

Numeric Field Formatted For Currency Used In A Text Formula Field Looses Formatting?

So a numeric field formatted for currency looses its currency formatting if picked up as an element in a text formula field? (ie looses "$" and more crucial any decimals?) So if your numeric field is $159.00 when picked up in the text formula field it appears as simply 159

Other than including the lost formatting as a text element in the formula, is there another way to ensure it appears (more concerned with the lost decimal places than the "$" sign).

Formulas and functions
Tables and fields

14 Replies

Sort By
Show More
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    10 years ago
    =text(+[number],"$#,###.##")   Sorry, left off the closing quotation mark.
  • CarlosSantiago's avatar
    CarlosSantiago
    Qrew Trainee
    9 years ago
    FYI - I was using this formula to display a discount (negative number) and it was dropping out the thousands place (i.e. instead of showing "-$1,500.00" it was showing "-$500".  The way the Thousands variable is set up, it kicks in if the number is greater than 1,000.  Well, it's also true if it's less than -1,000.  I added the Abs function to get it to work:

    var text Thousands =
     If(Abs($Value)>=1000,ToText(Int(Abs($Value)/1000)));
  • LauraLaura1's avatar
    LauraLaura1
    Qrew Member
    8 years ago
    Hey there! I have some currency fields that will include dollar amounts in the millions, requiring more than one comma ($3,000,000.00 for example). Anyway there is something I can add to the above formula to make this work for those values?