Forum Discussion

Snowy34's avatar
Snowy34
Helper 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)

Anonymous's avatar
Anonymous
Not applicable
3 years ago

This might be helpful also to anyone looking for this.   I used variables (following along with the math provided by the same website the above poster referenced).   Everything matched up.   

% Diff Pow vs Non Pow RMAs =
VAR _absolutedifference =  [Power Sup count] - [Non Power Sup Count]
VAR _averagebetween = ([Non Power Sup Count] + [Power Sup count] ) / 2
VAR _percentdiff = (_absolutedifference / _averagebetween) * 1
RETURN
_percentdiff