I’m dealing with Square transaction exports. Exported fields are limited to groups, any one of which doesn’t include all the data I need.
I’m compromising and having to calculate the merchant fee on my own.
I’m using val(money(«Net Sales»*.0275)).
The issue is if Net Sales - 5,910.00, the result of «Net Sales»*.0275 is 162.525.
The money function converts this to 162.52 and Square actually took 162.53.
Can someone show me a different function to use or a formula which will round up if it ends in 5 as Square is doing?