You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Price escalation with expression - Subscription Management

Hi,

I have use case for using CPI in subscription management as follows.

Previous CPI - 339

Current CPI - 367

CAP - 5%

CPI to calculated as Current_CPI-Previous CPI/Current CPI% and compare the result with CAP% which is 5.

I have converted this use case as below formula & updated in subscription. But it did not do anything.

CASE
WHEN NVL((({TM_US_CURRENT_PERIOD}-{TM_US_PREVIOUS_PERIOD})/{TM_US_PREVIOUS_PERIOD})*100,5) > 5
THEN NVL(((({TM_US_CURRENT_PERIOD}-{TM_US_PREVIOUS_PERIOD})/{TM_US_PREVIOUS_PERIOD})*100),5)
ELSE 5
END

Please suggest if this is correct or any other option to acieve this use case.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!