0 Replies Latest reply: Jun 21, 2013 6:58 AM by Deepak Kumar RSS

    Expression Issue

    Deepak Kumar

      =

      Dear All,

       

      I am Facing one Issue. I want  Year on Year Compariosn using below Expression. But i donot know where i Have to put the Current Year Variable Now i put the condition in above four lines but the output is coming zero.

       

      Can any one tell for this kind of Expression where i have to put the Year Condition.

       

       

       

      (

      Num((Sum({<FiscalYear={"$(vCurrentYear)"},Month=,Quarter=,Day=,NumTransDate={"<$(vMinDate)"}>} RecievedQty)

      +Sum({<FiscalYear={"$(vCurrentYear)"},Month=,Quarter=,Day=,NumTransDate={"<$(vMinDate)"}>} WH_RecievedQty)

      +Sum({<FiscalYear={"$(vCurrentYear)"},Month=,Quarter=,Day=,NumTransDate={"<$(vMinDate)"}>} IssuedQty)

      +Sum({<FiscalYear={"$(vCurrentYear)"},Month=,Quarter=,Day=,NumTransDate={"<$(vMinDate)"}>} WH_IssuedQty)),'##0.00'))

      +

      Num((

      sum(RecievedQty)+Sum(WH_RecievedQty)

      +

      sum(IssuedQty)+Sum(WH_IssuedQty)

      ),'##0.00')

      /QDenoNum

       

       

      Thanks,

      Regards

      Deepak