Beast Mode not selectable in Summary Number

MichaelClark
MichaelClark Member
in Charting

I have the Beast Mode code below using a CASE statement and it is populating the column Review CI.  I want to count the number of "Yes" results (or In Two) in the column and display in the Summary number.  I am not able to select Review CI when choosing Use all values.  Any assistance would be helpful and much appreciated.

 

Michael

 

(CASE when CASE
WHEN `InKACE` = 'Yes' AND `InMcAfee` = 'Yes' AND `InAD` = 'Yes' THEN 'In All'
WHEN `InKACE` = 'No' AND `InMcAfee` = 'Yes' AND `InAD` = 'Yes' THEN 'In Two'
WHEN `InKACE` = 'Yes' AND `InMcAfee` = 'No' AND `InAD` = 'Yes' THEN 'In Two'
WHEN `InKACE` = 'Yes' AND `InMcAfee` = 'Yes' AND `InAD` = 'No' THEN 'In Two'
ELSE 'In One'
END = 'In Two' then 'Yes' else 'No' end)

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Hi @GuitarMan2020 

     

    Summary numbers only support beast modes which are aggregates (MIN, MAX, SUM, AVG etc). You could wrap your CASE statement in either a MIN or MAX depending on the logic you require. If any record has 'Yes' and the end result should be 'Yes' then use MAX. If any record has 'No' and the end result should be 'No' then use MIN. (This works because of alphabetical sorting).

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

This discussion has been closed.

Categories