Hi,
I am trying to create a % by taking a filtered value in Column A and dividing it by other, multiple filters in Column A. I am able to create the numerator, however, when creating the denominator, I can't get it to register more than one filter. I've tried 'AND' and 'OR' statements, but no avail. See below:
SUM(CASE
WHEN Material Description
= 'SALT FLUX-57.5/37.5/5'THEN Quantities Reverse
ELSE 0
END)
/
(SUM(CASE
WHEN Material Description
= 'CLASS I 3004 BODY STOCK SCRAP' OR '3104/3204' THEN Quantities Reverse
ELSE 0) +
(CASE WHEN Material Description
= '3XXX RSI(DROSS)' THEN Quantities Reverse
ELSE 0) +
(CASE WHEN Material Description
= '3003 CLEAR/BARE' THEN Quantities Reverse
ELSE 0))
END
As stated, the denominator only registers the first case ('CLASS I 3004 BODY STOCK SCRAP' OR '3104/3204' in this case). Any advice on how to group the denominator filters?
Also, I tried creating dynamic segments for each of these and did, but don't know if I can reference dynamic segments in formulas. I tried but got not result.