Skip to Content
0
Former Member
Nov 18, 2011 at 09:14 AM

Summation Problem in variables

30 Views

Hi Experts,

i am having a problem while doing Sum for a field.

I created a Variable by the name Plan Cost and the calculation for that is

Plan Cost = "Order Quantity * Sales Price"

I am having Material Group and Material in my report.

Material Group, Material, Order Qty, Sales Price, Plan Cost.

MG1 m1 4 10 40

MG1 m2 3 15 45

MG1 m3 6 20 120

My Total comes to (40 + 45 + 120) = 205

But if i remove the Material from the report

The total comes to

Material Group, Order Qty, Sales Price, Plan Cost.

MG1 13 45 585

585 = (13 * 45)

Now the total comes as 585, while i want 205.

Can anyone help me how to solve this.

I want plan cost to calculate for Each material in the material Group and than calculate.