Formula to add line item from Monthly set up to QTY
I would like to ask if this is possible. There are 3 modules done but 1 module is set to monthly and the other is set to quarterly. See below for the illustration:
I had to create an illustration since I cannot provide screenshot from the model due to confidentiality.
This is the revenue module.
And then they created another module set to quarterly for the recon.
The idea is to add both yellow cells on th Mar 19 column of the Final Revenue module. So the mar 19 formula in the final Revenue Module would be Revenue Module.Revenue mar19 + Recon to AFS module. Recon to AFS Revenue Mar19. Currently we are not getting the values or getting a circular reference as an error.
Not so sure why they build the model with different modules instead of a single one.
Appreciate if you can provide some ideas on how to execute this one.
Thanks and Regards,