January 4, 200719 yr 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!
January 4, 200719 yr 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.
Create an account or sign in to comment