Year over year cost growth

[BI_Dev]

Hi - We are trying to calculate YOY cost increase based on the % provided for each record.

Here is an example of data and the expected output (Escalated Cost)

ID	Escalated %	Year	Base Cost	Cost %	Escalated Cost
1	3%	2023	$4,806,750
1	3%	2024	$4,806,750	$144,203	$4,950,953
1	3%	2025	$4,950,953	$148,528	$5,099,481
1	3%	2026	$5,099,481	$152,984	$5,252,466

Base cost is '$4,806,750' for current year and there should be an increase of 3% every year based on the previous year cost.

Year 2024 = Base cost
Year 2024 = Base cost + 3% cost Escalated = Escalated 2024 cost
Year 2025 = Escalated 2024 cost + 3% of Escalated 2024 cost = Escalated 2025 cost

Year 2026 = Escalated 2025 cost + 3% of Escalated 2025 cost = Escalated 2026 cost

Is this doable ?

Thank you much!

[Rams-]

Hi,

As per your logic I have implemented the below expressions:

For Cost% : if(Year = 2023, 0, (RangeSum(Above(.3*[Base Cost],0,1))/ 10))

Escalated Cost:  Sum([Base Cost])+ if(Year = 2023, 0, (RangeSum(Above(.3*[Base Cost],0,1))
/ 10)) 

Below is my Output:

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!