Formula assistance! SUM?


Re: Formula assistance! SUM?



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.



View solution in original post

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!