cancel
Showing results for 
Search instead for 
Did you mean: 

Key Figure - Aggregation

Former Member
0 Kudos

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

CONTRACTIDDocument IDSpendValueThreshold =  Spend / Value *100Threshold (To be) =  Total Spend / Value *100
ABC123456100ABC3002500014
ABC654321200ABC6002500024

Thanks

Akshata

Accepted Solutions (1)

Accepted Solutions (1)

anshu_lilhori
Active Contributor
0 Kudos

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

Answers (3)

Answers (3)

Former Member
0 Kudos

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

former_member186053
Active Contributor
0 Kudos

Hi,

Do as suggested by Phani, later you use that formula in Threshold (To Be) = New formula/Value * 100.

Regards,

Vengal.

former_member976
Active Contributor
0 Kudos

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.