HELP! Need to update a feild in a layout with a sum

[working.account]

Hello all,

I have a column in a layout that is called "Sum Sales". This feild is currently blank. "Sum Sales" consists of "reg sales" plus "other Sales" Which is populated in my layout.

Does anyone know how I write a script that will populate the "sum sales" with the result of (reg sales + other sales)

Thanks in advance!

[agtjazz]

Is Sum Sales a calculated field?

I would suggest making it a calculated field (Define Database).... and you probably in this case do not want to have the field change, so you would un-toggle the 'Do not store calculation results-- recalculate as needed' under Storage Options

With a calculated field, you won't need a script.

Hope that helps.