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
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