Multiplying Totals in Microsoft Report Builder

Kinetic ERP
,
1

Hello.

I have a report here…

image

I managed to calculate what “our quantity” * “our cost” which results in the pink square.

My next step is where I am stuck.

  1. Green column: I want to total up the rows that will result under “our cost”. So the total cost of the items by themselves. Not the cost of them times the quantity, but the total of their cost as if they were each a quantity of one.

  2. Red column: I want the total cost of all the rows that result. So the total cost of the line (qty * cost) * each line maybe?

Purple is just to showcase that this row is outside the group.

Please point me in the direction that will help me figure out how to calculate these expressions correctly.

RDL file attached: SupplierSt.rdl (80.6 KB)

Thank you!

2

If I"m understanding you correctly, you should just be able to wrap a Sum() around the value you’re trying to total. Green Total would be Sum(RcvDtl_OurUnitCost) and the Red would be Sum(your expression in pink).

3 Likes
3

That worked, thank you!!!

2 Likes