Member formula does not work on parent entity level

Hi,

We have a planing application and we are using member formulas on some accounts. It calculates properly on base entities. However the same calculation is applied on parent entity level, which is not what we want. We want the data to be calculated on base entities only, and aggregate to parent entities. We have done extensive testing, including setting the Data Storage attribute to DynamicCalc or DynamicCalcAndStore, and check/uncheck the Two Pass Calculation. We also tried to fix the member formula to run on base entities only, but we are getting #Missing on parent entities. Then we ran an aggregation