Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can write this if else formula using set analysis ?
If label = 'A' and client = 'X' then Sum(measurefield1)/If label = 'B and client = 'Y' then Sum(measurefield2)
If label = 'C' and client = 'X' then Sum(measurefield3)/If label = 'D' and client = 'X' then Sum(measurefield4)
If label = 'E' and client = 'X' then Sum(measurefield5)
If label = 'F' and client = 'X' then Sum(measurefield6)