I currently have a case statement within a beast mode calculation that does as follows:
case
when `advertiser name` like '%Microsoft%' then 'paid'
(745 lines similar to the one above)
else 'NA'
end
I get error: Invalid Formula : This calculation is too long
Not sure on how to go about this. Any advice or direction on what to do would be great.