on 01-28-2014 6:00 PM
HI All,
I require a different calculation for the Grand total(Overall Result row) as compared to the subtotals.
In our case ,We want to calculate Grand total result as the average of sub-total results where as subtotal result performing summation operation.
Scenario:
In the attached report,
-> Observe PO Document with multiple invoices at line item level which means PO Amt will be same for all the invoices under same PO document number.
PO Document Invoice PO Amount
12345 1 750
12345 2 750
12345 3 750
Result 750 (Using exception aggregation)
In order to achieve this we have used exception aggregation in PO Amount with reference to characteristic 'Reference Key' .(See Result row in yellow colour)
-> Observe Result row in green colour which defines the total PO Amount for particular PO document number(summing of PO amts at Item level).
-> Observe overall result which is summing the amounts in green rows,.
Instead of summing , i need the averages of PO Amounts with respect to all PO document numbers at Overall result level.
Hi Venkat,
For that particular key fugure,try the calculate Result As options you will get the desired results.
rgds
SVU
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Venkat,
Try using PO Amount as a selection where you add invoice as constant selection. Then in calculations tab select calculate result as average.
Hope it gives an idea
Regards
Yasemin..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Did you try with simple setting for your PO Amount KF(Calculate Result as Average)? Currently, it is Nothing Defined or Summation has been defined.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try with Exception Aggregation as Average of all values that are not equal to zero--Reference characteristic as Invoice.
Amend your existing exception aggregation with the above one.
See if this works or not.
Regards,
AL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.