on 10-03-2008 7:40 AM
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.
mahesh
Hi Mahesh,
Instead of Creating a New Formula, Create a Calculated Key figure, and the properties screen choose Enhance tab --> Select Before Aggregation, you will get the correct value even though Your Document is not in Drill down.
Regards
Sreekanth.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Any updatessssssssssss.
Edited by: Mahesh Kumar on Oct 3, 2008 9:13 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
9 | |
9 | |
7 | |
7 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.