Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Below is how I'm calculating my expression.
If Label = 'A' and Client = 'X' ,Sum(Measure),
If Label = 'B' and Client = 'Y', Sum(Measure)
If Label = 'C' and Client = 'Z', Sum(measure)/If Label = 'D' and Client = 'W', Sum(measure) )))
The first 2 if statements worked perfectly but the last if statement to calculate the division is not working. It doesn't display any value on the dashboard. How can I do the sum / sum using if statements ?