Sum calculation of field values
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-28-2022 11:17 AM
Hi,
I have a table with two integer-type fields, can I calculate the sum of the values of these fields in a third integer-type field in the flow designer?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-28-2022 01:34 PM
Hi,
This can be achieved if you "toggle scripting on" - please see attached small highlight.
Once you've done that you should follow the logic as per the example that I provided, replacing short_description with field3(the one that contains the sum of field1 and field2).
Kindly note, that I presumed that the record is the one identified in the trigger. If that's not the one that field3 is part of then you will have to position yourself on it - it's easy - if you write fd_data. and wait a couple of seconds options will appear.
Hope this helps!
Tudor