Question:
hi all,
I want to calculate value of goods sold in BW reporting(from InfoCube) by multiplying Product Price x Quantity. Since Price is either summated or Maximum value taken or Minimum value taken Price x Quantity will not give the right figure. How to solve this ?
Can you Help me to solve this.
Thanks all,
Jenni.
Answer:
Jenni,
You can create new keyfigure in you InfoCube and update it durring the data load. In the update rules multiply Price * Quantity and update your key figure this will resolve your problem.
Regards,
Ali