Exclude Zeros From Average

I am calculating an average but I do not want the zero values to be included in the average. How can I exclude them?

Best Answer

Answers

  • How to SUM the last 4 non zero values in the time series???

     

    Example - if i have a data as - 

    12,0,4,0,8,12,9,0,5,0,3,5,7,0,3

    Answer should be 18

    12,0,4,0,8,12,9,0,5,0,3,0,7,3,3

    Answer should be 16

     

    Any ideas????

     

  • not entirely elegant but....you'll need to use a "signal row" = if number row <> 0 then 1 else 0….next add calc row that divides ‘number row’ by "signal row" (the count)…and in blueprint mode change the calc row from sum to ‘formula’.

    See attached pictures