Member Formula is not working accurately
Summary:
I have developed Cashflow through console formulas. Top parent is ClosingBalance_Cash and under which these are the Childs:
1: Cashflow from the operating activities(Dynamic Calc)
2: Cashflow from investing activities(Dynamic Calc)
3: Cashflow from Financing Activities(Dynamic Calc)
4: OpeningBalance_Cash(Dynamic Calc) (Have member formula to bring the previous period closing balance as the opening for the current period)
5: OpeningBalance_Input(Store member to input the number for first time opening)
I have two issues:
1: Data is not rolling up accurately on the top parent "ClosingBalance_Cash" correctly
2: The figure floats on the opening balance member is not the closingbalance_cash from the previous period but the "OpeningBalance_Cash" from the previous period