This content has been marked as final. Show 3 replies
I am using direct discovery for my fact table. using aggregate function and if condition that time failed the expression.
Case 1 : Sum(Amount) -- Working
Case 2 : if(REGION='ALL',Amount,0) -- Working
Case 3 : Sum(if(REGION='ALL',Amount,0) ) -- Failed
How to solve the problem in case 3.