calculate rows in table fields in a workflow
I have users that complete a spreadsheet for daily activities every month. Columns at the end of the row perform calculations on that row. For example calculating the number of times a kid was seen by a therapist. I would like to be able to use a table field and do the calculations in a workflow. My current work around is only available to those with a local or hybrid system and that is to create a view in local sql database and do the calculations in sql.
Eric Bosworth
shared this idea
-
J Pendleton
commented
I need to be able to have Where calculations in table formulas. For example - when the location chosen is Home, I need to be able to count how many times that happened so that there can be a final calculation totaling the number of miles defined as home times the number of times they drove from or to home... so add 1 to the current calculation field where Location = Home.