Summing Totals

[Nanette]

I've been trying to sum a couple of totals using the code below because the
report is broken down into Fiscal Months. The following does not work.

Does anyone know what would work?

=Sum(NZ([BLQtyReqPD],0))+Sum(NZ([RBLQtyReqPD],0))

 

[Nanette]

Please ignore this. This one is working well.

This is the one that's not working.

=Sum(NZ([BLPricePD],0))+Sum(NZ([RBLPricePD],0))

 

[Nanette]

I'm going too fast for myself. What I was considering that I needed is this:

=Sum(NZ([BLPricePD],0))+Sum(NZ([RBLPricePD],0))*Sum(NZ([BLQtyReqPD],0))+Sum(NZ([RBLQtyReqPD],0))

But this does not work. The equation seems to stop at the * sign. Any
suggestions?

 

[Marshall Barton]

I'm going too fast for myself. What I was considering that I needed is this:

=Sum(NZ([BLPricePD],0))+Sum(NZ([RBLPricePD],0))*Sum(NZ([BLQtyReqPD],0))+Sum(NZ([RBLQtyReqPD],0))

But this does not work. The equation seems to stop at the * sign. Any
suggestions?

I've been trying to sum a couple of totals using the code below because the
report is broken down into Fiscal Months. The following does not work.

I don't see why that doesn't return a value. It may not do
what you want, but it should not produce an error.

Note that there is no need to use Nz in the Sum function.
All the aggregate functions ignore Null values.

Just a guessomg now, maybe you want to use:

=Sum(BLPricePD)+Sum(RBLPricePD*BLQtyReqPD)+Sum(RBLQtyReqPD)

or maybe the field names imply that you want:

=Sum(BLQtyReqPD*BLPricePD)+Sum(RBLQtyReqPD*RBLPricePD)