8 Replies Latest reply: Oct 20, 2015 12:39 PM by Yeo Poh sai RSS

    How to insert eXP field into my YTD script ?

    Yeo Poh sai

      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 :-




      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.