Hi,
I have a module that shows the full-year forecast amount for various expense categories.
It also compares the current forecast (2021) to the prior forecast using the formula PREVIOUS(Full year forecast). That was fine in 2020, but now we are in 2021, the prior forecast shows nil.
How can I fix this so it picks up the previous forecast (2020)?
Thanks