Still relatively new to Anaplan, but need formula assistance. I have created an input module for users to input data for a region with list attributes of internal/external and discretionary/non discretionary.
Then created a GBP conversion module:
I'm now on an output module, but I can't seem to sum on the internal/external or discr/non-disc?
That's because of the subsidiary views.Take these two line items out of the module and create a module of their own without Time dimension and it will work fine,
Are you saying that every product/transaction/time intersection is unique and needs input on a quarterly basis? If that is the case then you need to get rid of Time dimension in your Source Module and use Time Period formatted Line items and then use SUM on that line item.
Ha! no problem - we all are! Well my input and calculation modules are based on quarters and my output module is year? I didn't think this was the issue as it seemed to be pulling all quarters' data into the totals?
Thanks for taking the time to explain this. I've removed the timescale on agents and disc/non disc, however, it means when individuals input info on a quarterly basis, they are not able to select these options? so the sum on these attributes doesn't quite work. Is there another workaround to this?