Forum Discussion
Percentage difference between two columns
Hi,
Try this measure
=SUM([On Hand Bal])/((SUM([On Hand Bal])+SUM([safety stock]))/2)
This very much depends on what you want to show. But generally speaking you would make a measure dividing the sum of one with the sum of the other.
Measure = DIVIDE(SUM([On Hand Bal]) , SUM([safety stock]) , BLANK())
Good day Tax628
The issue with this is it still is wrong,
As the first line % dif between 134 and 200 is 39.52%, not 67% I'm not sure where that 67% is getting pulled from.
Hi,
How did you calculate 39.52% The numerator is 66. What is the denominator?
As per below
So I have used a pie chart and it worked fine but when done in a table as per below its showing 67%, I wanna get away from using the BOM filter on the side as I got more than one visual on the screen. Thx for your help.
Hi,
Try this measure
=SUM([On Hand Bal])/((SUM([On Hand Bal])+SUM([safety stock]))/2)