my report look like this:
|
Item |
price |
ordered |
delivered |
back order |
back order amount |
|
book |
5 |
300 |
100 |
200 |
1000 |
|
200 |
100 |
100 |
500 |
|
TOTAL PER ITEM |
300 |
200 |
100 |
500 |
|
pencil |
1 |
50 |
10 |
40 |
40 |
|
40 |
40 |
0 |
0 |
|
TOTAL PER ITEM |
50 |
50 |
0 |
0 |
|
Grand Total |
350 |
250 |
100 |
500 |
the problem is, i cant get the right value for grand total Back Order Amaunt. I use running total to get the grand total for Ordered, use summarize for Group Item to get grand total for Delivered and i use formula to calculate grand total for Back Order. I have no idea how to get the grand total for Back Order Amaunt. anybody can help me??
Edited by mein - 03 Nov 2009 at 2:16am
IP Logged
