Custom export: reimbursable amount of an expense

rs55

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?

Nicole Trepanier

@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.

Nicole Trepanier

@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}}

rs55

Thanks for the quick response.

rs55

Perfect, that works.

albert1988

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

Nicole Trepanier

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