Forum Discussion

Snowy34's avatar
Snowy34
Icon for Helper III rankHelper III
7 years ago
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...
General Comment
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    Try this measure

    =SUM([On Hand Bal])/((SUM([On Hand Bal])+SUM([safety stock]))/2)

Snowy34's avatar
Snowy34
Icon for Helper III rankHelper III
7 years ago

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.

 

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

Try this measure

=SUM([On Hand Bal])/((SUM([On Hand Bal])+SUM([safety stock]))/2)