I have a requirement where I have actual and planned values for each month and I have to calculate the ratio of Act/Planned and then I have to compare the % value received with a table where we have different increment values based on different percentages as shown below:
Employee Act/Plan(the calculated measure)
A 20%
B 35%
C 14%
And the Look up table is :
Percentage Increment
10% 100£
20% 200£
30% 300£
The user can select time period like a month or qtr ,the values are coming fine if the user select 1 month but if he selects qtr then it is not able to show the correct increment value.Can anyone suggest some solution please.
