View Single Post
 
Old 09-23-2014, 11:44 AM
Jake0254 Jake0254 is offline Windows 7 32bit Office 2013
Novice
 
Join Date: Sep 2014
Posts: 1
Jake0254 is on a distinguished road
Default 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.
Reply With Quote