Member Formula - Net Calc
Hi all,
I am having trouble with a member formula that essentially subtracts interest expense from interest income:
I'm sure I am missing additional dimensions/qualifiers in the me...
Forum Discussion
Good morning, try including the minus sign in the quote / formula that is enclosed by quotation marks. The Design and Reference Guide offers a wide range of examples, e.g.:
Those should be removed:
Despite that, this could just as well be a dynamic calculation in my view. Or the net account could just be the parent of the two base members. Saves you the need to re-calculate, and, more importantly, avoids unnecessary data being written (i.e. stored) into the database.