Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Blank Formula Help

Hi.   I am trying to categorise numerial responses into 3 different categories.   If they answered between 0-1 - I want to categorise that as 0-1 Day Active If they answered between 2-4 - I want...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    You could use ISFILTER() function.

    Column = IF(ISBLANK('Table'[Answer]),BLANK(),IF('Table'[Answer]<1,"0-1 Active",IF('Table'[Answer]>=2&&'Table'[Answer]<=4,"2-4 Active","5+ Active")))

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

You could use ISFILTER() function.

Column = IF(ISBLANK('Table'[Answer]),BLANK(),IF('Table'[Answer]<1,"0-1 Active",IF('Table'[Answer]>=2&&'Table'[Answer]<=4,"2-4 Active","5+ Active")))

 

Best Regards,

Jay