topic Re: RE: Exclude Zeros From Average in Anaplan Platform
https://community.anaplan.com/t5/Anaplan-Platform/Exclude-Zeros-From-Average/m-p/48099#M6305
<P>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’.</P><P>See attached pictures</P><P> </P><P> </P>Mon, 01 Jul 2019 16:54:02 GMTbhill52019-07-01T16:54:02ZExclude Zeros From Average
https://community.anaplan.com/t5/Anaplan-Platform/Exclude-Zeros-From-Average/m-p/559#M3249
<P>I am calculating an average but I do not want the zero values to be included in the average. How can I exclude them?</P>Tue, 30 Oct 2018 05:52:29 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Exclude-Zeros-From-Average/m-p/559#M3249PrevContributor2018-10-30T05:52:29ZRE: Exclude Zeros From Average
https://community.anaplan.com/t5/Anaplan-Platform/Exclude-Zeros-From-Average/m-p/560#M3250
You can do this by adding a line item to count the values you want to include, i.e.: add a line item 'Count' = If 'Value' <> 0 then 1 else 0. Then you can calculate the average with a formula that is 'Value' / 'Count'. You will need to change the summary type of this line item to either 'Formula' or 'Ratio'. If you choose ratio, you need to specify the Numerator / Denomator below, so you would select 'Value' / 'Count' in this case.Sat, 02 Mar 2013 06:41:11 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Exclude-Zeros-From-Average/m-p/560#M3250PrevContributor2013-03-02T06:41:11ZRe: RE: Exclude Zeros From Average
https://community.anaplan.com/t5/Anaplan-Platform/Exclude-Zeros-From-Average/m-p/34571#M3251
<P>How to SUM the last 4 non zero values in the time series???</P><P> </P><P>Example - if i have a data as - </P><P>12,0,4,0,8,12,9,0,5,0,3,5,7,0,3</P><P>Answer should be 18</P><P>12,0,4,0,8,12,9,0,5,0,3,0,7,3,3</P><P>Answer should be 16</P><P> </P><P>Any ideas????</P><P> </P>Thu, 19 Jul 2018 14:46:40 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Exclude-Zeros-From-Average/m-p/34571#M3251lokeshsinghal702018-07-19T14:46:40ZRe: RE: Exclude Zeros From Average
https://community.anaplan.com/t5/Anaplan-Platform/Exclude-Zeros-From-Average/m-p/48099#M6305
<P>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’.</P><P>See attached pictures</P><P> </P><P> </P>Mon, 01 Jul 2019 16:54:02 GMThttps://community.anaplan.com/t5/Anaplan-Platform/Exclude-Zeros-From-Average/m-p/48099#M6305bhill52019-07-01T16:54:02Z