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 member formula, but everything was the exact same except the account of course.
Any direction would be greatly appreciated!
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.
The way Calculate works, it's meant to create records in the database that will contain the results of a calculation. To do that, you always have to specify a set of destination coordinates for the records you will be creating; that has to be on the left hand side of the assignment operator (=). So in your case, the formula should probably look something like this:
api.data.calculate("A#Interest_Expense_Net:F#Cash_Input = A#WC_Interest_Income_ThirdParty:F#Cash_Input - A#WC_Interest_Expense_ThirdParty:F#Cash_Input")
You should probably review the parts of the Design & Reference Guide that deal with Stored Calculations and Member Formulas. I would also recommend the OneStream Finance Rules and Calculation Handbook, available at online bookstores (Amazon etc).