Beast Mode not selectable in Summary Number

MichaelClark

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)

GrantSmith

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).