如何在时间序列中总和最后4个非零值???
示例 - 如果我有一个数据为 -
12,0,4,0,8,12,9,0,5,0,3,5,7,0,3
答案应该是18
12,0,4,0,8,12,9,0,5,0,3,0,7,3,3
答案应该是16
有任何想法吗????
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’.
请参阅所附图片