I have a function that is not calculating the formula EBITDA_NetDebt when i reference it as a function. The incorrect amount that keeps pulling is the A#EBIT_UnrestCorpCash which is an entered value from a HFM journal.
If i don't reference a function the formula EBITDA_NetDebt works fine by itself and calculates correctly.
The function is supposed to have EBITDA_NetDebt pull a value from the function NetDebtCalc which needs to be zero before March 2009. i want it only showing a value on and after March 2009.
here is the expression:
Hs.Exp "A#EBITDA_NetDebt" & NonesNoC3 &"=" & NetDebtCalc()