Mail Merge Field - Trying to divide time however receiving !Syntax, ;
Hello
I am merging to a csv dataset and have a field called 'TotalQuantity' and another called TotalPeople
There are currently five sample records in my table...
Total Quantity: 05:00, 05:00, 02:00, 10, 13
Total People: 5, 5, 2, 10, 13
I need to be able to divide the total quantity by total people.. I have created the {= {MERGEFIELD TotalQuantity } / {MERGEFIELD TotalPeople} }
However this returns a Syntax error. Please help!
FYI, if I try and do it on excel, it works. So it isn't a formatting issue that I'm aware of.
Thanks, Jake.
|