Forum Discussion

Snagalapur's avatar
Snagalapur
Helper IV
1 year ago
Solved

Custom format values in measure / cards

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.

Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    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.

2 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    1 year ago

    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.