Error message:
An issue has occurred during processing. We are unable to complete the request at this time.
Code:
(case when `Make_It_Personal` is null then 0
when `Make_It_Personal` = 'N/A' then 0 else `Make_It_Personal`*1 end)
The field name is "Make_It_Personal" and it's in text format. Possible values are (0-10, N/A, and NULL) so I used above code to convert this field into numbers so I can aggregate. It's giving me error only for feb, 2018 but not Jan 2018 or Dec 2017. I used excel to see if there's any other values i didn't account for or non-printable characters but found none. After dedupping the field it's still only 0-10, N/A, and null in excel. i also did the aggregate function outside of case function but not working.
I have attached the underlying data with sensitive fields removed. There are 2 other fields that are part of the calculation using the same code and they are working.. Literally have no clue why this is happening. HELP!!! PLEAE HELP!