Beast Mode not selectable in Summary Number

MichaelClark
MichaelClark Wichita Falls, Texas ⚪️

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 Indiana 🔴
    Accepted 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).

Answers

This discussion has been closed.