Hello Team, I cannot get away from this ongoing problem. It probably me, but.... I am going around and around in circles and never bottoming this out.
I cannot get links right and am being forced to corrupt my models with freeform formulas.
An example: I need to in initially total each company's pay cost. I have 2 salaries and wages modules for each company: local pay cost and central pay cost. I need to total each companies local and central pay cost. The pay cost module is basically the standard modano salaries & wages module inserted twice for each company.
I created a total pay cost module by inserting a 3 salaries and wages module and then deleting the Assumptions component. I then referenced the category column to the central pay cost assumptions module so that the 17 different pay grade names were picked up. The problem is the freeform formulas I have introduced that sum the pay cost for each grade of the local pay cost and central pay cost from the Outputs modules for local pay cost and central pay cost. This produces a freeform formula error. I have fumbled unsuccessfully with the links and have created multiple further problems that show that is a circular problem!
Hi Nick,
This post is a little outside the scope of the Modano Community Forum, which is designed to provide a platform for our users to assist each other with common challenges implementing Modano. Module linking is a very common challenge for (even our most expert) users, but your issue here seems very specific to the model you're developing, and is therefore more a support request than a forum post.
Hence, can you please either:
As a general comment, freeform formulas should be avoided wherever possible, as they prevent your model from being scalable and rollable, etc. From a linking perspective, this means having a very clear understanding of the linkages between each module in your workbook, which is why our experts spend 40% of the model development time planning and mapping out the model structure and links before diving into Excel.
Your current challenge looks complicated, but not unusual, so I'm sure our support guys will be able to point you in the right direction. M.