Hi @Jonathang thanks for reaching out and it’s cool to hear you have discovered the new auto calculation feature. 

You are spot on that, in order to complete these formulas during the inspection a you would need to enter a 0 for those questions you mentioned to complete the formula. Your idea about having a ‘default value’ if left blank is something a number of customers have raised in it’s a feature we will likely investigate further in the future. 

We are also close to releasing another improvement to the calculations feature, i.e being able to apply logic conditions to automatically calculated results, so keep an eye for that. 

All the best,

Paddy

I have been running into the same issue

In two of my templates I add 32

 different responses of two groups, one group is “dry” products, the other is “liquid” products.

My question in the template for each area is “does it have liquid and dry products, if the answer is No they still need to enter a 0, otherwise my calculation link of the total is not working.

During the Better event in Nashville it was mentioned that calculations had Excel features, the only thing you can do is add, subtract, multiply, divide and exponent.

It would be great to have a SUM: feature in calculations.

Could look something like “SUM $ Dry Products 

Hey @JJV ! I have checked in with the team for an update on support of zero values. They currently reviewing where developments stand within calculations and I should have more information to share by later next week. Thanks in advance for your patience! 

In regard to supporting SUM in calculations, this is also something I should be able to speak to next week. That said, I encourage you to submit this as an idea so yourself and the rest of the Community can easily track development progress  

Hi ​@JJV, hope you’re well. 

I waned to follow up off the back of ​@Bianca.Taylors message about some improvements to calculations, and i have some good news. 

We are just kicking off the work now to support basic and more advanced functions (like sums and default zero’s) as well as supporting calculations over repeating sections. It’s going to take a bit of time, but we should be able to support most of this within the first half of next year if all goes to plan. 

If you have any other feedback in regards to calculations, please let us know

This is really promising as it’s a real deal breaker for signing up for premium, as we have a number of quality spreadsheets we use, although they’d be better suited to the app. Being able to carry out calculations based repeat sections would also be great, (for individual pallet checks for example), although I understand that could be quite complicated.

I’d also like to see an addition for the ability to hide calculations questions, not just hiding the calculation information itself. There’s not much use for the user to see the calculations during the audit, other than creating a long list.

I am experiencing another issue with calculations not working.  For some reason, questions set as number fields allow you to type commas.  However, if you type a comma, the calculations questions do not calculate because they don’t know how to handle the comma.  Number questions either need to not allow commas, or the calculations questions need to know how to handle them.