Hi,
Is it possible to display a calculated average value based on previous inputs? Here is an example scenario:
Sources of income are captured in different fields: Src1, Src2, Src3, Src4, Src5 and Src6.
(Src1, 2 and 3 are options of a multi-select question. Src4, 5 and 6 are individual questions)
Average has to be calculated only for the income sources that have a value. So if only Src1, Src2, Src4 and Src6 have values, then Average income= (Src1+Src2+Src4+Src6)/4
This is one way I can think of:
Step 1: Increment a field (Total) by 1 everytime an income source field is entered (Problem: Not sure how to do that)
Step 2: Create a calculate field and use the following formula to calculate average:
(coalesce(${src1}, 0) + Coalesce(${src2}, 0) + coalesce(${src3}, 0) + Coalesce(${src4}, 0) +coalesce(${src5}, 0) + Coalesce(${src6}, 0))/Total
Question: Is there a better way to do this? If not, how should I calculate the 'Total' field? It needs to increase by 1 everytime src1, src2, src3 etc are populated.