AnsweredAssumed Answered

Calculte field

Question asked by joselryi on May 18, 2018
Latest reply on May 18, 2018 by Joseph.Drahos@iowadot.us_IowaDOT

Hi,

I have a survey which has four fields and another field which calculates the avg of this four fields. My calculated field is configured this way:

 

(((${ROWS_CT1} + ${ROWS_CT2} + ${ROWS_CT3} + ${ROWS_CT4}) div 4)))

 

I got a requirement where it is not mandatory all fields to be filled. So, if only two fields was filled my avg should be by two, if only three fields was filled my avg should be by three and so on.

 

I was wondering how to implement that on survey, maybe some if's to check whether the field is filled or not, any ideas?

Outcomes