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.

Are your field's internal braces (i.e. { }) created via Ctrl-F9? You can't just type them.

Furthermore, it looks like some of your data are times, expressed in HH:mm. Unless your 'Total Quantity' is always a whole number of hours, you will not get meaningful results with your current approach, as Word's formula fields cannot evaluate times this way. A moderately-complicated field code would be needed to convert the time into minutes, do the division then convert the results back to HH:mm -

{QUOTE{SET AvgTime {={={MERGEFIELD Total_Quantity \@ hh}*60}/{MERGEFIELD Total_People} \# 0}}{=INT(AvgTime/60)*100+MOD(AvgTime,60) \# "00:00"}}

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practicable to add them via any of the standard Word dialogues.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]