TM1 Forum

Hi,

I need some help in feeding a calculated consolidated cell. The attachment shows the test cube.

A simple explanation of what I'm trying to do here: I'm trying to have % calculation based on "Change" divided by "Opening" but only on subtotal level.

I tested feeders on detail level and it works but once changing the rule to calculate on C: level it won't.

Any help is appreciated.

Kenneth

Do you need to feed anyway, or can you for example work with fixed report layouts ?
At least for the cells involved in the calculations, or can they be put alongside fed cells in the same report and don't need feeding themselves ?

Hi Wim,

Thanks for the response. Unfortunately the answer is yes. Basically the whole purpose is to get the % calculation on consolidated level only.

In the example shown, I need the 43.53% and couldn't show it unless the % calculation is applied to all leaf elements.

Kenneth

Wim Gielis wrote: ↑Fri Jun 11, 2021 7:56 pm Do you need to feed anyway, or can you for example work with fixed report layouts ?
At least for the cells involved in the calculations, or can they be put alongside fed cells in the same report and don't need feeding themselves ?

Have you considered making % a consolidated element with $ as it's child. As long as there's no requirement to input % and it's always a calculation this is an option that'll remove the need for feeder statements.

Great idea!

Will definitely try and report.

Thanks a lot!

Keneth

burnstripe wrote: ↑Sun Jun 13, 2021 10:40 am Have you considered making % a consolidated element with $ as it's child. As long as there's no requirement to input % and it's always a calculation this is an option that'll remove the need for feeder statements.

burnstripe wrote: ↑Sun Jun 13, 2021 10:40 am Have you considered making % a consolidated element with $ as it's child. As long as there's no requirement to input % and it's always a calculation this is an option that'll remove the need for feeder statements.

This is the way.

The suggestion to make % the parent of $ works.

Thanks a lot!

Kenneth