Direct Discovery: Expression Failed

[muniyandi]

Hi,

I am using direct discovery for my fact table.  using aggregate function and if condition that time failed the expression.

Ex:

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.

Thanks,

Muni.

[muniyandi]

Hi Experts,

pls , help for me.

[sujeetsingh]

It should work

[muniyandi]

Hi Sujeet,

just try out in direct discovery method, it's not working.