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.
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 ?
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014 https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
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.
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.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.