Reports summation of keyfigure value
IN BW 3.5 development of Query.
Iam facing issue in reports summation of keyfigure value.
we build reports on INFOSET.
1)Totally i build 4 reports to satisfy requirement.---1.Detail 2.comp code3.commodity 4.vendor wise .
2)in Detail report i can able to show all the values .
3)when it comes to company and commodity iam facing problems, like if iam using the document number results are fine, if i removes drill down on the document no then results are wrong. In company code and commodity thy required to see the final values only.
4)we used formula for calculating invoice quantity .
formula= 'Payment Amount-Local' / 'Number of Records'
basically INFOSET was getting duplicate records ,so what we did was divided each keyfigure with 1ROWCOUNT(no of records). if we used Key figure directly then aggregate of the final value we can show. Here we are getting duplicates so we created formula to calculate the Key figure values.
one more thing in 3.5 for formula/CKF we dont have option called Exception aggregation for overall result.
Its urgent.Suggest me.