Forum Discussion

Snagalapur's avatar
Snagalapur
Icon for Helper IV rankHelper 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)"...
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.
danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

Hi Snagalapur 

 

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