on 03-26-2015 5:04 AM
Hello All,
Can you please hlep me how do we achieve below scenario?
Currently we have KF Threshold being calculated based on the individual spend value for a Contract & respective ID/Doc ID but we want to have a cumulative of the Spend to be caluclated in the Threshold instead of single value
Example
Threshold (Existing) = Spend/Value *100 = (300/25000)* 100
Threshold (To Be) = Total Spend/Value *100 = (900/25000)* 100
I have tried exception aggregation to achieve this but I did not get desired results
CONTRACT | ID | Document ID | Spend | Value | Threshold = Spend / Value *100 | Threshold (To be) = Total Spend / Value *100 |
ABC | 123456 | 100ABC | 300 | 25000 | 1 | 4 |
ABC | 654321 | 200ABC | 600 | 25000 | 2 | 4 |
Thanks
Akshata
Make a new formula and then use SUMCT function
SUMCT(Spend).
Finally use this formula for calculation purpose.
Make sure that you do not suppress the result row for characteristic.
You can also search more on the function which i mentioned.Hopefully this should work in your scenario.
Regards,
AL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for all your response
@ Vengal/Phani - I have tried using the Exception aggregation but the result never differed
@Anshu - I have used SUMCT and its working, any idea to hide the result?
Thanks
Akshata
Message was edited by: Aks P
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Do as suggested by Phani, later you use that formula in Threshold (To Be) = New formula/Value * 100.
Regards,
Vengal.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
create the new formula -> put the formual inside -> hit the aggregation tab -> use the exception aggregation -> total -> use the reference char -> ID -> save it and execute it.
-Phani.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
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.