We have a frustrating error where an automation is finding certain time-log records and supposed to add up the decimal value of the collected time logs. Adding it up via the automation provides incorrect values.
It will however give the right answer when the ‘loop’ action adds the decimal values into our number field directly, but not when we try adding them all in a workflow variable then just updating the final number field once with the sum.
This screenshot shows that it’s getting the values and listing them correctly in our check comment:
I think this has something to do with the way the calculation field handles using its output variable in the calculation so as an example, this should work:
Thank you @Jason that was very helpful. Your approach did indeed work for me.
I am still very curious though if @Tim might have further insight on the reason that the calculation field output is not accurate.
In other systems like Globiflow/Podio Workflow Automation we would successfully use Calculation variables in this exact way many times and I can’t think of a strong reason why it should work any different here in Tape…?