Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
in the attached screen the for a given code and year.. i will get some percentage . And there is another table which will have percentage ranges.. based on the range values star values are given for each Code. In the attached example for code AAP2 and year 2014.. the Rate % is 47% (0.47) and in the range table it is given that for the code AAP2 there will be begin percentage and end percentage based on the range it should assign star 1. please advise how to write the expression. Thanks for your help.
(Aggr(If((rate%)>=PtileBeg and (rate%)<=PtileEnd,Star),Star,MEASURE_ID) )
can anyone help me.. @massimo Gross
maybe with extended interval match in the script
i dont have timestamp or date columns . Do you think .. it will still work.
If possible is there any syntax you can help me with
Can you please help me with this . if there is a chance.
(Aggr(If((rate%)>=PtileBeg and (rate%)<=PtileEnd,Star),Star,MEASURE_ID) )