I'm having problems with a calculated field using blended data. I hope that somebody can help.
The formula I'm trying to get to is: (2018 Actual for March)/(2016 Actual for March)+1] * PLAN (for June 2018)
I got the ACTUAL 2018 growth but can't multiply it with the Plan amount.
For federal, for example, it would be 100.4%*$175,091
Thank you so much!
Apologies, I do not have the time right now to open your workbook right now (heading to a meeting), what is the error you are seeing? And, have you properly defined the relationships between the sources?