Year to Date Sum

[RppDuck]

I am trying to calculate Delivered Qty of an Item YearToDate. The following formula gives me the total of all Item.

If {tdsls045.ddat} in yearToDate
then Sum({tdsls045.dqua}) else 0

There is no Details Section in this report as it is a Summary.
Parameter:{Delivery Date} in {?DT_BETWEEN}
Group #1 is: Items - {Item Number}
Group #2 is: Customer - {Customer} {Delivered Qty} {YTD Delivered QTY}
Footer #1 is: Sum(Delivered Qty)

Any Ideas on how to Calculate this?

Thanks

 

[goranm]

Hi !

I think, if you in your formula write like this:

If {tdsls045.ddat} in yearToDate then
{tdsls045.dqua}
else
0

and put the formulafield in the detail section, then you can create a summary on the field for your Group #1.

/Goran