Computation with Price Escalation

Hi Guys,

I would like to ask something regarding a formula I have been working on. See the table below.

Price Escalation formula = Input

Avg Selling Price = The Jan 13 value is constant referenced to 2.3 which is in another module. While the succeeding months starting Feb 13 to Mar 14 the formula is Avg Selling Price*(1+Price Escalation).

I tried the formula IF Price Escalation = 0 then Avg selling Price else Average Selling Price*Price Escalation.

I also tried IF Previous(Avg Selling Price)=0 then Avg Selling Price else Avg Selling Price*Price Escalation.

I still do not have the right calculation on my Line Item. Need a little input on this.

Appreciate it.

Regards,

Tags

Modeling

Calculation Functions

Accepted answers

Hi @Jsdeloria21

I am sure not about logic what you have explained. From the screenshot it looks like the formula is not correct for Avg selling price as well.

If i am assuming constant value to be 2.3 for Jan 13 and price escalation is 1% in Jun, how the average price will be 2.4 as per the formula you have provided.

1% of 2.3 =0.023 and in total it will be 2.323

Anyway i have tried to replicate :

Please provide more details on the formula then I can help you more on this.

Thanks

Akhtar

All comments

Hi @Jsdeloria21

I am sure not about logic what you have explained. From the screenshot it looks like the formula is not correct for Avg selling price as well.

If i am assuming constant value to be 2.3 for Jan 13 and price escalation is 1% in Jun, how the average price will be 2.4 as per the formula you have provided.

1% of 2.3 =0.023 and in total it will be 2.323

Anyway i have tried to replicate :

Please provide more details on the formula then I can help you more on this.

Thanks

Akhtar

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…