Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All
I've a table where I'm using a measure to calculate the average and if conditions like:
if(Ind = 'L',Sum(Sales))/Sum(minutes) and this is computed across a table for each employee and his dept.
Based on this value, I need to provide an incentive, hence I've a range of incentives like
Range Min | Range Max | Value |
0 | 110 | 0 |
110 | 130 | 1.2 |
130 | 150 | 1.4 |
150 | 100000000 | 1.8 |
If the computed value falls in the given range, I need to add a measure to the table stating the incentive the employee would get.
Thanks in advance!
Regards
Pratyush
The IntervalMatch is a much more elegant solution. Thank you for that!