Topic: Function add alternativeSubscribe | Previous | Next
David Jedland 8/15/2019
Hi,
I've made an expression for describing 'Activity level' for how many houses that will be built each year, and adding that to the previous year as to keep track of how many houses that has been built until every given year, without retroactively changing how many houses that has already been built
.
It will be a function of some key assumptions that may vary from year to year. This is my solution using the function 'Add', but as you can see, there's quite a few lines as I'm adding over 30 years.
Add(
It will be a function of some key assumptions that may vary from year to year. This is my solution using the function 'Add', but as you can see, there's quite a few lines as I'm adding over 30 years.
Add(
2017;Key#1*Key#2*Key3;
2018;Key#1*Key#2*Key3;
2019;Key#1*Key#2*Key3;
2020;Key#1*Key#2*Key3;
........
2050;Key#1*Key#2*Key3;
)
I've tried solving this problem using Sum and Cycle, but to no success. Does anyone know how to write this expression more efficiently?
Thankful for any advice!
David
Thankful for any advice!
David