Forum Discussion
Solved
Percentage difference between two columns
Good evening all, I'm trying to get percentage difference between two columns and I'm having some issues with it my table is, (FYI the table code have duplicated skus) Item O...
Hi,
Try this measure
=SUM([On Hand Bal])/((SUM([On Hand Bal])+SUM([safety stock]))/2)
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?