Is it possible to compare the overall result and use it in the condition?
Material1 belongs to group1
Material 2 and 3 belongs to group2.
No. of group is the counter on the material group.
Mat1Qty|No.of group|Mat2Qty|No. of group|Mat3Qty|No. of group| ResultQty|Result No.of group
1| 1 | 0 | 0 | 1 | 1 | 2 | 2
2| 1 | 0 | 0 | 0 | 0 | 2 | 1
The report should compare the result of qty with the result of no. of group. If the qty >= No.of group, it should be displayed in the report. Else, it shouldn't be displayed.
How to get this result?
Edited by: P R on Feb 6, 2009 3:12 PM
Edited by: P R on Feb 6, 2009 3:27 PM