This content has been marked as final. Show 2 replies
For this table, I want to calculate %UA Negative such that when A = B then count all the Negatives in the UA column and divide that by total number of results where A = B.
So for A=1 and B=1, %UA Negative = 1/2 = 0.5
IF [A] = [B] THEN
SUM(IF[UA] = 'Negative' THEN 1 ElSE 0 END)/COUNT([UA]) END