Hi,
I am struggling to create a simple beasemode in a datasetview, grouped by quarter.
I am creating a new cost column, containing usd_cost for each account unless it is one of the 6 listed accounts and then use the marketing_cost.
I am unable to validate the beast mode ("Whoops error!!" is not helping)
The column names are correct, I am not clear whether it is the grouped dataset view that is causing the issue, or if as the accounts is a text field there is a format mismatch, or something else…
How do I troubleshoot this?
CASE
WHEN `account`IN ('5704','4941','4216','4194','4217','4213') THEN `Sum usd_marketing_cost`
ELSE `Sum usd_cost`
END
All suggestions appreciated…
Thanks
John