Forum Discussion

Lexey's avatar
Lexey
Helper I
8 years ago

Percentage between two values

Please help in solving one problem. You need to calculate the percentage as the ratio of [delta plan] and [plan]. Tried different options but have not yet found solutions.
Need Help
Lexey's avatar
Lexey
Helper I
8 years ago

I need row context.,
 1 row = [delta plan]/[Values of budget]
 2  row = [delta plan]/[Values of budget]
3 row = [delta plan]/[Values of budget]

 

you get a total percentage that doesn't suit me. Thanks

Floriankx's avatar
Floriankx
Solution Sage
8 years ago

You could try SUMX(Table;[delta plan]/[Values of budget].

 

This is for a Measure.

Calculated Column would just be [delta plan]/[Values of budget]

 

I'm not quite sure wether your columns is name Values of budget or plan.

 

Please try and let me know.

  • Lexey's avatar
    Lexey
    Helper I
    8 years ago

    Thanks
    I didn't get quite the right result

     

    delta % plan = sumx('fact'; [delta plan]/ [Values of budget])

     

    • Floriankx's avatar
      Floriankx
      Solution Sage
      8 years ago

      What would be your expected results?

       

      For the total row I see it makes no sense.

      You may have to change to delta % plan = sum([delta plan]/sum[Values of budget]