Forum Discussion

vpatel55's avatar
vpatel55
Icon for Kudo Commander rankKudo Commander
4 years ago
Solved

Format to two decimal places

I'm trying to use FORMAT to get a measure to report to two decimal places. For example, £1.73M. However, the output is only showing £1.7M. It needs to be manually formatted because it will format par...
Need Help
  • AntonioM's avatar
    AntonioM
    4 years ago

    Hi vpatel55 ,

     

    I think you need two 0s at the end to force the decimal places, instead of the #s earlier. 

     

     

    FORMAT([Value],"£#,,.00M")