Forum Discussion

hanami001's avatar
hanami001
Frequent Visitor
8 years ago
Solved

Percent Difference from Measure

He Everyone,

 

I want to get percent difference from 2 columns, that is created from a measure.

For column: TS_%Diff from target, this is calculated the difference from column Rev Target and Rev Actual but the result is incorrect.

 

TS_%Diff from Target = DIVIDE([Revenue Cal] , [TS_Rev Target by %Rev Actual] , BLANK())

 

Please advise me on this problem.

 

Thank you!

  • Hi Flotiankx,

     

    Please ignore this problem, due to I have misunderstood on the calculation.

     

    Thank you.

2 Replies

    • hanami001's avatar
      hanami001
      Frequent Visitor

      Hi Flotiankx,

       

      Please ignore this problem, due to I have misunderstood on the calculation.

       

      Thank you.