1 of 1 people found this helpful
I would recommend a different approach. What you are trying to calculate is the difference between two values displayed in a table - a table calculation should do the trick:
[Gap] : MEDIAN([Earnings]) - LOOKUP(MEDIAN([Earnings]),ATTR(IF [***] = "Male" THEN 1 ELSE -1 END))
Compute using [***].
Thank you very much. That did work. I will need to read up some more on table calculations. Thank you for your help.