Forum Discussion

TheCreepster1's avatar
TheCreepster1
Icon for Helper II rankHelper II
8 years ago
Solved

Distinct Count based on percentage measure

Hi All,   Not sure if what I'm trying to achieve is possible but I have some information at Site/SKU level where I am performing some aggregate calculations that I then want to perform a distinct c...
Need Help
  • jthomson's avatar
    jthomson
    8 years ago

    Some sort of nested IF would probably work for this if you've only got a small number of options to work with - something like:

     

    PercentageGroup = if([currentpercentagemeasure]<0.6,"50-60%",if([currentpercentagemeasure]<0.7,"60-70%"

     

    and so on

jthomson's avatar
jthomson
Icon for Solution Sage rankSolution Sage
8 years ago

Some sort of nested IF would probably work for this if you've only got a small number of options to work with - something like:

 

PercentageGroup = if([currentpercentagemeasure]<0.6,"50-60%",if([currentpercentagemeasure]<0.7,"60-70%"

 

and so on