7 Replies Latest reply: May 20, 2016 2:58 PM by PAUL YEO RSS

    Sum({<IsInYTD={1}, Year={">$(=year(today())-2)"}> }{<eXP={"eXP"}>}Amount)*-1)

    PAUL YEO

      Hi All

       

       

      My below expression working fine :-

       

       

      Sum({<IsInYTD={1}, Year={">$(=year(today())-2)"}> } sales)

       

       

      But now i not measure by sales , instead i meansure by eXP filed. When compute sum by eXP the expression is below :-

       

       

      Sum({<eXP={"eXP"}>}Amount)*-1

       

       

      So my imagine expression should be below :-

       

       

      Sum({<IsInYTD={1}, Year={">$(=year(today())-2)"}> }{<eXP={"eXP"}>}Amount)*-1)

       

       

      But it display null value. Where go wrong ?

       

       

      Paul