LindaMadiSmoke
09-05-2022Data Storage
MALException
Hi
I need help with this error I receive after I have created a custom column and I want to use the same columns to do calculation on.
Example of the custom column:
Select
(Case When [NPS_rating_Answer_Value]>=9 then
Count([Result_ID]) Else Null END) as "Promotors"
FROM [result_answer_questions.csv]
group by [NPS_rating_Answer_Value],[NPS_rating_Answer_Value]
The calculation I am trying to do :
([Promotors]-[Detractors])/[Total_NPS_Answr_Value]
But I am getting the below error:
MALException:run_default_logic_inst_prll failed: failed to apply parallel default logic
How do you solve this error: