Format to two decimal places

[vpatel55]

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 part of a larger sentence.

Here is the formula being used. Any help would be appreciated.

FORMAT([value],"£#,##,,.0M"

Thanks.

[vpatel55]

Fabulous, thanks @AntonioM !

[AntonioM · Accepted solution]

Hi @vpatel55 ,

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

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