Fill with average of existing data

martinf

<p>Hi</p>
<p> </p>
<p>is there a way to fill an empty data with the average of all existang data of that field?</p>
<p> </p>
<p>Day    data</p>
<p>1          22</p>
<p>2          24</p>
<p>3          28</p>
<p>4</p>
<p>5          21</p>
<p>6          33</p>
<p> </p>
<p>Would like to put 25,6 in day 4 because (22+24+28+21+33)/5 = 25,6</p>
<p> </p>
<p>Thanks</p>
<p> </p>
<p>MartinF</p>
<p> </p>
<p> </p>

micajblock

<p>Try creating an aggregate that is the average then the expression on the data item should be something like this:</p>
<pre class="_prettyXprint">
if (row["data"]==null) {
   row["average"];
}
else {row["data"]}</pre>