Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for
Did you mean:
Creator II

## Year over year cost growth

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!

Labels (3)

• ### Script

Creator

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!