AnsweredAssumed Answered

Currency format for thousands in Calculated Fields

Question asked by bokenrosie on Feb 27, 2014
Latest reply on Feb 27, 2014 by philmodjunk

Title

Currency format for thousands in Calculated Fields

Post

     I need to get a number formatted with thousands in my calculated field.  I found:

"$" & Let ( [ d = Round ( YourTable::FIeld ; 2 ) ; i = Int ( d ) ; f = ( d - i ) * 100 ] ; i & "." & Right ( "0" & f ; 2 ) )

I did not need cents so changed it to

     "$" & Let ( [ d = Round ( ParAmount ; 2 ) ; i = Int ( d ) ; f = ( d - i ) * 100 ] ; i )

     How do I add comma separators?

Outcomes