Issue with double counting bed types

Question

* We added new bed types to eventually move from the old "All Beds, single, double" 
* I inputted the data into the new bed types
* Went to double check flow into other modules and found that they are being double counted even though I blanked the original columns out.
* I am not sure why it is still counting All Beds even if it is blank
* Hopefully it is just a simple fix I missed please advise

I tried switching summary to formula and it fixed the overall total but still showed the 136 in "All Beds*

vanreign · Answer

Great to hear Dee! I can definitely relate to stepping away from a project and coming back to it with new eyes. Way to get it! Cheers, James

DeeWarren · Answer

https://community.anaplan.com/discussion/comment/175102#Comment_175102

Thank you for your input, unfortunately the formula settings didn't change the outcome, however I realized that the formula was pulling the previous year's input if no new input was made in that bed type. So for FY27, I just overrode the inputs it was pulling in from the previous year's input for the old bed types, and I believe my issue is fixed.

Going to test future years but I think I'm good to go.

vanreign · Answer

Hi DeeWarren, It looks like All Beds is still getting 136 from DATA_LOAD Housing.Beds through aggregation, not from the old input column. That would explain why blanking the original input did not remove it, and also why changing summary to Formula fixed the total but not the All Beds row.

It might be worth checking the summary setting on DATA_LOAD Housing.Beds. The maybe if All Beds is a parent/summary item. Also, if the formula should only pull loaded data at the lowest bed type level.

If All Beds should no longer hold a value, setting the source line item summary to None may fix it.

I hope some of those ideas may help. -James