Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you attach any same file and display the data in table and show what result you want in any image format or excel format according to your data here.