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
