Report math formula not working

Random127
Expensify Customer Posts: 2
Hello,
I would like to calculate the difference between an expense report total and reimbursable amounts. In other words, find the non-reimbursable amount. I have the following formula in my report, but it returns a blank value even though the constituent parts return values when used individually:
{math: {report:total}-{report:reimbursable}}
What am I doing wrong?
Best Answer
-
I anyone is interested, the following formula allowed Excel to calculate the non-reimbursable amount:
{math: {report:total:nosymbol} - {report:reimbursable:nosymbol} }
Problem solved.