cancel
Showing results for 
Search instead for 
Did you mean: 

Goal Calculation issue ; Interpolate function

chandrasekhar7
Discoverer
0 Kudos

Hi All ,

I try to use the interpolate function but it's not working for one of the condition. As per client requirement , If result is the amount between min & max value then calculation should be :

( Diff Result - Min Value ) / ( Max Value - Min Value ) .

Can you please guide me what's the correct method to be used ?

Expectations :

The actual result is below or equal to the minimum value of the target ( Payout ) result should be 0%.

If result is equal or above the value given as Max then Target results ( Payout ) should be 100%.

If result is the amount between min & max value then Target results ( Payout ) as below.

( Diff Result - Min Value ) / ( Max Value - Min Value ) .

Thanks,

Chandrasekhar Siddi +91-88840-13838 .

Accepted Solutions (0)

Answers (1)

Answers (1)

xavierlegarrec
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi siddi9698

Business goals calculation methods mathematics cannot be changed.

They are all documented here:

https://blogs.sap.com/2022/07/12/understanding-interpolate-and-step-business-goals-calculations-in-v...

If interpolate doesn't work for your customer then you need to have them load the business goal payout % directly instead of loading all the metrics (as per the conclusion of the blog).

All the best,

Xavier