Currency format for thousands in Calculated Fields
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?