Trace Feeder and Check Feeder Disagree
Posted: Fri Aug 30, 2024 3:07 pm
I have a very simple rule and feeder like such:
['Total Departmental Income (Loss) - 000'] = ['Total Revenue - 000'] - ['Total Departmental Expenses - 000'];
['Total Hotel GOP - 000'] = ['Total Departmental Income (Loss) - 000'] - ['Total Undistributed Expenses - 000'];
Feeders;
['Total Revenue - 000'] => ['Total Departmental Income (Loss) - 000'];
['Total Departmental Expenses - 000'] => ['Total Departmental Income (Loss) - 000'];
['Total Departmental Income (Loss) - 000'] => ['Total Hotel GOP - 000'];
This is all within an account dimension. I'm having an issue where Total Departmental Income (Loss) is not being fed, and thus Total Hotel GOP is not being fed when Total Revenue - 000 is zero but Total Departmental Expenses - 000 is not zero.
Trying to trace why this is not working, I check feeders on Total Departmental Income (Loss) - 000 and it says that the cell is not fed. But when I trace feeders on a singular leaf cell part of the consolidation Total Departmental Expenses - 000 it says that Total Departmental Income (Loss) IS FED as is Total Hotel GOP. Why would check and trace feeders disagree about the exact same cell intersection being fed?
['Total Departmental Income (Loss) - 000'] = ['Total Revenue - 000'] - ['Total Departmental Expenses - 000'];
['Total Hotel GOP - 000'] = ['Total Departmental Income (Loss) - 000'] - ['Total Undistributed Expenses - 000'];
Feeders;
['Total Revenue - 000'] => ['Total Departmental Income (Loss) - 000'];
['Total Departmental Expenses - 000'] => ['Total Departmental Income (Loss) - 000'];
['Total Departmental Income (Loss) - 000'] => ['Total Hotel GOP - 000'];
This is all within an account dimension. I'm having an issue where Total Departmental Income (Loss) is not being fed, and thus Total Hotel GOP is not being fed when Total Revenue - 000 is zero but Total Departmental Expenses - 000 is not zero.
Trying to trace why this is not working, I check feeders on Total Departmental Income (Loss) - 000 and it says that the cell is not fed. But when I trace feeders on a singular leaf cell part of the consolidation Total Departmental Expenses - 000 it says that Total Departmental Income (Loss) IS FED as is Total Hotel GOP. Why would check and trace feeders disagree about the exact same cell intersection being fed?