Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Help with FORMAT

Hello all!   I created a calculated column to format other column with some Net Sales values.     test = FORMAT(Summary[Y5 NS (USD)];"$#,##0,,M")     Basically, if I have a value of $ 17.08...
Need Help
Show and Tell
Tips and Tricks
parry2k's avatar
parry2k
Super User
6 years ago

Anonymous try this

 

test = FORMAT(Summary[Y5 NS (USD)];"$#,##0.00,,M")

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello parry2k 

     

    Did not work :S

     

    $3.500.000 become $3,500,00.00M

     

    $17.086.863 become $17,086,863.00M