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


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


    Example - if i have a data as - 


    Answer should be 18


    Answer should be 16


    Any ideas????


  • bhill5

    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