Custom format values in measure / cards

[Snagalapur]

Hi All,

Please suggest how to custom format values in measure.

below code is not as expected - 

Act v. Bud = FORMAT(

    SUM([actual_op])- SUM( [budget])/1000000,  "#,##0.0,,M;(#,##0.0,,M)")

expected format-

Thank you.

[danextian]

Hi @Snagalapur 

What is your input? What is SUM([actual_op])- SUM( [budget])/1000000?

[rajendraongole1 · Accepted solution]

Hi @Snagalapur - 

Act v. Bud = FORMAT(
(SUM([actual_op]) - SUM([budget])) / 1000000,
"#,##0.0,,M;(#,##0.0,,M)"
)

you can replace the fields values as per your model. Hope this works.