Adding fields. (2 replies)
- Ensure the Script Evaluation Checkbox is marked, otherwise you will end up with a literal (see attached screenshot).
- Ensure the field types of the two fields you are adding is either Integer or Decimal, if they are marked as Text you may end up with the two values being concatenated.
- Sum is an aggregate function.
I also recommend you work through the training manual as this covers a lot of script examples.
That works great. Thanks for the help.
Can you provide the syntax for adding two field values together and presenting the total in a separate field. I've tried Sum(%field1,%field2). Sum(%field1 + %field2). %field1 + %field2.