Skip to Content
0
Jun 18, 2020 at 12:50 PM

Calculating the age of a project few years ahead

116 Views

hello,

I try to evaluate the revenue of a project based on its age, during few years ahead.

I’ll try to make it clear with an example :

I have a Project dimension, with an attribute "first year"

I need to evaluate the revenue 5 years ahead (with a formula using the calculation "project_age") meaning that I need to be able the create the "project_age" that way:

Project X “first year” = 2010

project X age, current year =2020-2010=10

project X age, next year =2021-2010=11

project X age, 2 years ahead =2022-2010=12

...

project X age, 5 years ahead =2025-2010=15


In this case not only I need to transform the text “first year” as transactional data (using ATTRIBUTE in data action), but I also need the use the date dimension as transactional data.

I also must work on the year level – and I don’t know how to do it (it always requires a leaf level)

Moreover, I need a dynamic “current_year” / “next_year” etc, that will update the project’s age every year automatically, and that will act as transactional data.

How would you suggest doing it?