Would it, or is it possible to create a calculation from answers in an inspection? For example, I am inspecting an air conditioner on a recreational vehicle or camper and I need to determine how efficient the air conditioner is functioning. This is called Delta-T. To do this I measure the temperature of the air entering the air conditioner and the temperature of the air leaving the air conditioner. The difference between the two numbers is the delta-T.
I would like to have a question that ask for the temperature of air entering the air conditioner, followed by a question asking for the temperature of the air leaving the air conditioner. Finally, the third question would automatically calculate the delta-T from the answers from the previous two questions.
Hello,
Yes this can be done, please see image attached.
Q1 air in
Q2 air out
Q3 delta t
have all of the answers set to numbers, on the detla t question click format (number) select calculation and put $air in minus sign - $air out that will automaticall populate the answer
Hi@RV P. I. thank you for your enquiry and @Ady thanks so much for jumping in and sharing your use case!
For more info on how to use this feature check out the below link to the help centre article: https://help.safetyculture.com/en-US/002991/
All the votes from this idea have been transferred.
Is it possible to evolve this feature even further???
It would be advantageous to include the slider function within the Calculations function, either by allowing you to set the minimum/maximum fields with numbers set in previous questions (by using the same, current format, $’name of questions’, and the same inverted function, by allowing the values declared when using the slider function to be made available to use in calculations.
Furthermore, can the formula functions be expanded to include greater than >, less than <, equal to =, with a warning notice being issued of the calculations results in a false result?
thanks,
Thomas
Hey@TMcG ! You raise a great idea! I want to make sure our Community has the best visibility of it so I encourage you to submit a new idea so there’s no confusion associated with this one and the idea it’s been merged into. Let me know if you have any concerns ![:blush: 😊](https://cdn.jsdelivr.net/emojione/assets/png/1f60a.png?v=2.2.7)
I would like to see more advanced formulas, involving IF statements with <, >, =. I would also like to be able to calculate the difference between date and date/time questions.
For example, I have “Production Date/Time of First Unit” and “Production Date/Time of Last Unit.” I want to calculate the days between them including the time as a decimal for partial days.
Another example - I have a calibration standard value and a question for the actual measured value. You may have 3 sets of these for 3 calibration standards to measure. I need to say “SUM(IF(value1-standard1 > xyz, 0, 1), IF(value2-standard2 > xyz, 0, 1), IF(value3-standard3 > xyz, 0, 1))”. That would result in a total sum of 0 to 3. I can then use logic on that result to say if >= 2 you pass.