3 Replies Latest reply on Feb 27, 2014 4:11 PM by philmodjunk

    Currency format for thousands in Calculated Fields

    bokenrosie

      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?