Hi,
I need help with a formula. I have a module dimensioned by product, meeting, and entity.
In my new module, it is dimensioned by product and entity and my formula is a direct link to the % line item in the previous module.
I need it to pick up the total for Product A for example at 50%, but it is currently picking up 5%. How do I go about doing this?
Thanks in advance
Hello,
Let me summarise your issue in a different words:
1) Source module dimensioned by [Products][Meetings][Entities]
2) Target Module dimensioned by [Products][Entities]
So target module contains less dimensions and by default Anaplan picks total for all meetings, but within specific product and entity.
If you pivot your source module in a following way: having Products in rows, entities in columns and meetings as a page selector, so you would be able to choose total for all meetings and then check data for specific product.
It might be that you have a formula summary in your source module which sums percentages according to their calculation logic.
If you could share some screenshots and more details - it will be easier to understand your issue.
Regards, Nikolay