0 Replies Latest reply: Apr 24, 2013 2:26 AM by Yojas Samarth RSS

    Expression is working in reduced application but not working in final Application

    Yojas Samarth

      Hi,

      In my requirement I have to create a pivot which consists of 3 dimensions Month,Business Unit,Grade in the hierarchical manner. In my 1st expression I am calculating Sum(Cost) and In my 2ndexpression I have to calculate reduction in the cost as compared with a particular month’s cost which user is going to select from a separate month field. If user selects Apr then my expression should work like sum(cost) in Apr – Sum(Cost) of other months.

      Selected month(Apr)-other month(May,Jun,July,...etc)/Selected month (Apr)

      I created one expression after reducing data in my application and it is working fine but when I use same expression in my main application then it is not
      working. I tried a lot but it is not getting changed.

      My expression is : 

      =if(Month1=vInputFrom,((sum({<EMPLSTATUS={3},Month1=,PAYRL_AREA-={00},EMPLGROUP-={9}>}ANSALARY)*VCurrency_INR)/vUnitSelector)/12,

      (((sum(Total<BU_NAME_SHORT,PAYSCALETY> {<EMPLSTATUS={3},Month1={'$(vInputFrom)'},PAYRL_AREA-={00},EMPLGROUP-={9}>}ANSALARY)*VCurrency_INR)/vUnitSelector)/12
      -((sum({<EMPLSTATUS={3},Month1=,PAYRL_AREA-={00},EMPLGROUP-={9}>}ANSALARY)*VCurrency_INR)/vUnitSelector)/12)

      /(((sum(Total<BU_NAME_SHORT,PAYSCALETY>
      {<EMPLSTATUS={3},Month1={'$(vInputFrom)'},PAYRL_AREA-={00},EMPLGROUP-={9}>}ANSALARY)*VCurrency_INR)/vUnitSelector)/12))

       

      Can anyone tell me how can I mould this expression so that it should work in my final application.

       

      Regards,

      Yojas