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)
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)