Custom export: reimbursable amount of an expense
I'm trying to add a column to our export that indicates the reimbursable amount of an expense. To do this I am taking the bit expression of the reimbursable field (0 or 1) and multiplying by the amount of the expense. My formula emulates the one in your guide:
{math: expense:reimbursable:bit * expense:amount:nosymbol}
However, it doesn't work. Nor does it work when I try any function (+ or ); nor does it work when I sub in a number for one of the data calls (e.g. {math: expense:reimbursable:bit + 2}).
Am I doing something wrong? Why doesn't this work?
Best Answers

@rs55 You aren't doing anything wrong. I've tested a bunch of different combinations of numerical formulas and I can't get any of them to work either. I'm having my team look into it and I'll update you as soon as I have any information.

@rs55 As it turns out our instructions were incorrect. Each formula within the formula needs to be in brackets. Try this one: {math: {expense:reimbursable:bit} * {expense:amount:nosymbol}}
Answers

Thanks for the quick response.

Perfect, that works.

Would anyone have a list of math functions available? Thx.

Hi @albert1988. You can find a list of math functions here. Let me know if you have any questions!