3 Replies Latest reply: Feb 13, 2014 9:20 AM by Muniyandi Vasimalai RSS

    Direct Discovery: Expression Failed

    Muniyandi Vasimalai

      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.