HFM Rules Combining adding, subtracting, dividing, and multiplying
Is there a set order of adding, subtracting, dividing, and multiplying in the same formula?
I know you must divide before adding.
What about multiplying?
A. Past12_Z = "("&PastDeb1Yr_12&")/13 + ("&PastLTDebt_12&")/13 + ("&PastEquity_12&")/13 + ("&Past41200_12&")/13" *(for reference)*
B. NetIncContOps_1="("&PastHSCNetInc_11&")/("&Past12_Z&")" *(works)*
C. NetIncContOps_2="((-1*("&PastIncdo_11&"))/("&Past12_Z&")" *(works)*
D. NetIncContOps= NetINcContOps_1&" + "&NetINcContOps_2&")" *(Not working)*
E. Hs.Exp "A#RTRN_CAP_PERC_YTD= ("&NetIncContOps&")" *(write to HFM)*
B and C work individually but when I try to add B and C in D I get an error when I calculate.
Can anyone please tell me what I am doing wrong?
Thanks!