Formula assistance! SUM?

Misbah
Master Anaplanner/Community Boss

Re: Formula assistance! SUM?

@CommunityMember113484 

 

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,

OR

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.

 

 

CommunityMember113484
Occasional Contributor

Re: Formula assistance! SUM?

it's the second one - so input will change quarterly. 

I've changed the input modules back to quarters and did the same with the output module, and this seems to have worked?!

Thanks for your help again!