Forum Discussion

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago
Solved

count by measure

hi there,   I have  a calculated measure to calculate the share % of each category, based on category share there is ranking, if % > 20 then A if % > 10 then B else C   I added the measure for ra...
Need Help
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    parry2k

     

    Try with this modification:

     

    RANK =
VAR Share = [% share]
RETURN
    IF ( Share > 0.10, "A", IF ( Share > 0.05, "B", "C" ) )

    Victor

  • parry2k's avatar
    parry2k
    8 years ago

    VvelardeThanks for getting back. Although I sorted it out but wanted to check how you experts will do. I will test your solution. Cheers!!

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
8 years ago

parry2k

 

Try with this modification:

 

RANK =
VAR Share = [% share]
RETURN
    IF ( Share > 0.10, "A", IF ( Share > 0.05, "B", "C" ) )

Victor