Good afternoon GoCanvas team:
I have an app for job estimation that relies on a loop screen to add labor positions as needed. Each position has an associated hourly cost for each. To arrive at the total cost, each line of the loop is multiplied by the "job duration" (expressed in days).
If I run the app using one scenario, for example using 3 days of work, I get a result of "x"
If I run the app using a second scenario, using 5 days of work, I get a result of "y"
However, imagine if I run the app using the first scenario, (3 days), then get to the final screen and realize that I needed to change my duration to the second scenario (5 days). I go back to the job duration and change the "3" to "5". The final result should be "y" - correct? Well, it isn't.
In that third scenario, I actually get a third result, "z". The reason is that the labor loop screen does not update the calculations in the loop once the "job duration" variable is changed.
I have examples and submissions to prove it all at a more detailed level.
After discovering upon job closeout that our bids fell short of our costs on a few jobs, we now recognize the bug after losing a few thousand dollars. My team now just starts over every time they have to change job duration. It shouldn't work that way. Math calculations should perform dynamically, regardless of whether they are in loop screens or not.
I've submitted this previously as a help ticket and was told "this is how it was designed to work". OK, that's fine. Time to please reconsider, because that makes no sense on any level to me. If excel did math this way, we'd all be in a lot of trouble.
Please help. Thank you!