A better calc than this for combining forecast and actual
All,
I have been tasked to create a member formula in an ASO cube. The idea is to have a scenario that holds actual data from the beginning of the year to the current month and forecast data from currmonth+1 to year end. I can do the report very easy in Financial Reporting but we have been asked to solve as a member formula so that all users can use the scenario. I have come up with a valid script that works correctly, but am wondering if there is a better code out there. Apprecate if you can share.
My code