1 Reply Latest reply: Apr 1, 2012 6:33 AM by Jagan Nalla RSS

    Need help in Expression

      Hello,

       

      Can any one help me in Expressions,i am facing some problem in creating expressions,the values is displaying in pivot chart but it is not matching with database values.

      I want to display the expressions for:

      1)standard quantity for actual production

      for this one i used expression is ''SUM({<Complete={'Y'}>} (QtyManufactured*UnitQtyReqd))''

      2)Actual Quantity issued

      for this one i used expression is ''SUM(QtyManufactured*UnitQtyReqd)- QtyIssued''

      3)Quantity variance

      for this one i used expression is ''SUM({<Complete={'Y'}>} (QtyManufactured*UnitCost*UnitQtyReqd))''

      4)standard cost for actual production

      for this one i used expression is ''SUM({<Complete={'Y'}>} (QtyManufactured*UnitCost*UnitQtyReqd))''

      5)actual cost

      for this one i used expression is ''SUM({<Complete={'Y'}>}(ValueIssued))''

      6)cost variance

      for this one i used expression is''SUM({<Complete={'Y'}>}(QtyManufactured*UnitCost*UnitQtyReqd-ValueIssued))''

       

      i am having these fields,QtyManufactured,UnitCost,UnitQtyReqd,ValueIssued,QtyIssued,etc..

       

      Regards,

      ba