We are trying to replicate the following set up and formulas from the below Excel snap shot into a Module. Currently the Module is set up where there are two list in the rows. In the Excel the formula for the Rollup is based on a calculation and we want to replicate that in Anaplan, but in Anaplan the Parent item automatically sums the children in the List. (attached is the Excel with the formulas in question highlighted in yellow).
Below is a screen shot of the Module we currently are using to try and create the Excel version.
To achive this in your case it can be used the following way: You have to create (in the same module) a separate line item with your calculation for Rollup and one more line item (number formatted) "1 as denominator" with no dimensions an a formula =1.
In ratio settings you have to put the Rollup formula in numerator and "1 as denominator" in denominator.
This way your rollup calc will be devided by one. Which means - stays as is.