I am trying to get the prior year total to then multiply it by a growth rate. (Prior Year * (1 + Growth Rate).
PREVIOUS( ) is not working because I do not have Year in the metric, and trying to add it was not working.
GrowthRate? is a Boolean that has TRUE starting in January 2026 and all periods forward
OriginalValue is a Number metric that has values monthly from January 2024 and all periods forward
What I’m trying to get is something like this:
IF(GrowthRate?, (Prior Year * (1 + Growth Rate), OriginalValue). I also can’t calculate off the OriginalValue metric because the Growth Rates will compound. If all years in OriginalValue were $1000 and I am adding 10% Growth I would want to see $1000, $1100, $1210, etc...
Unfortunately my 2025 occasionally has some 0 seasonality that is throwing off other metrics after this one.
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2025 | 1000 | 1000 | 0 | 0 | 0 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 |
2026 | =9000 * (1 + 10%) /12 | =9000 * (1 + 10%) /12 | =9000 * (1 + 10%) /12 | =9000 * (1 + 10%) /12 | =9000 * (1 + 10%) /12 | =9000 * (1 + 10%) /12 | =9000 * (1 + 10%) /12 | =9000 * (1 + 10%) /12 | =9000 * (1 + 10%) /12 | =9000 * (1 + 10%) /12 | =9000 * (1 + 10%) /12 | =9000 * (1 + 10%) /12 |
825 | 825 | 825 | 825 | 825 | 825 | 825 | 825 | 825 | 825 | 825 | 825 |