KAWRT KBETR KWERT
3.726,00 2.4, 89,42
814,00 2.4, 19,54
1.176,00 7.6, 89,38
988,00 2.4 23,71
3.019,50 2.4, 72,47
7.515,20 3.4 180,36
7.515,20 3.4 180,36
5.875,20 3.4 141,01
HI,
the values are fields of KONV table KAWRT is some amount, KBERT IS vat RATE on this aamount and KWERT is KBERT % on KAWRT amount(EG 2.4 % on 3726 is 89.42). Now the requirement is that i have to sum all the KAWRT and KWERT values which has similar KBERT rates and the result has to be printed in an invoice at the bottom right handcorner of an A4 sheet i.e in a variable window of a script as follows
2.4 % on amount(i.esum of all KAWRT which has 2.4 %) = sum of KWERT
7.6% on amoun(i.esum of all KAWRT which has 2.4 %) = sum of KWERT
like this i can have' n' number of VAT rates.
So my question is How can i print this it in a variable window.