8 Replies Latest reply: Oct 20, 2015 12:39 PM by PAUL YEO RSS

    How to insert eXP field into my YTD script ?

    PAUL YEO

      Hi All

       

      In my load script , i have below script :-

       

      If([Reporting Code]>=100 and [Reporting Code]<=374,'eXP') as [eXP],

       

      And i make use of below expression it work fine for pivot table to display Exp by month :-

       

      Sum({<eXP={"eXP"}>}Amount)/1000

       

      Now i am stuck when i try use of above expression , by Add YTD field , Hope some one can advise me. ( what i need is get the YTD expense amount. )

       

      My imagine expression should be some thing like this , but it does not work :-

       

      =sum(if(YTD and eXP='eXP',Amount))

       

      But it return wrong value.

       

      Paul