<p>Hi</p>
<p>I need to add a computed column.</p>
<p>I have guys who collect data from meters (but not every day). I would like to show in report the average by day for all days (average_by_day)</p>
<p> </p>
<p>Day incremental_field_meter average_by_day<br>
1 12 3<br>
2 3<br>
3 18 6<br>
4 6<br>
5 6<br>
6 6<br>
7 42 2 <br>
8 44 <br>
9 </p>
<p> </p>
<p>On day 3, we have 18, on day 1 we had 12 (18-12 = 6 / 2 (number of days) = 3 in average_by_day)</p>
<p>Advice: if I do (12-0-18) / -2 ('minus' days), I can have my value (3).</p>
<p> </p>
<p>I know I will need a variable to count day, etc...</p>
<p> </p>
<p>Someone can help?</p>
<p> </p>
<p>Thanks!</p>
<p> </p>
<p>Martin F</p>
