I have a the chart below that shows Demand by year. I would like to have the ability to add/remove demand by year to see what the chart looks like after changes. I have created 6 input boxes that create 6 unique variables, one for each year, and I would like to add a different amount into each input box/variable and have the chart update accordingly.
The base expression to get the demand is : (Value is the demand dimension)
I can get it to add the same variable input in all years by updating to the following: (vIncrease is the variable created by the input box)
I would like each variable to impact only a specific year in the chart so I tried the expression below:
This does not work. The results are the same as before I did any work with variables. I have tried removing the single quotes from the year, I put the string inside the original sum equation, I have added each if statement as a separate added amount and not embedded. Any thoughts on how to make this work, or if it is possible?