topic Re: How to calculate zero portion in % in Discussions

How to calculate zero portion in %

Thomas1 — Mon, 20 Aug 2018 11:31:45 GMT

What is the best way to create on formula column, which shows the portion in percent of values = 0 (Zero portion)?

In case the value column is empty, no portion value should be display in the formula column.

Re: How to calculate zero portion in %

txnelson — Mon, 20 Aug 2018 12:34:05 GMT

I am not exactly sure what you are looking for, but if you want to know the portion of the data table that contain zeros, I have included a couple of formulas that will do that

Re: How to calculate zero portion in %

Thomas1 — Mon, 20 Aug 2018 14:01:02 GMT

Thanks for your fast response.

I'm looking for formula which shows the portion of the vaule 0 only. Additional if the cell of the source is empty, the cell for the corresponding portion value should be empty.

I’m able to achieve this with the formula

If( Is Missing( :Value ) == 0,
            Col Sum( If( :Value == 0, 1, :Value > 0, 0, . ) ) / Col Number( :Value ),
            .
)

Despite getting the right result, I am wondering whether there is a better way to solve this. In particular with regards to apply this formula to sub groups.

Re: How to calculate zero portion in %

txnelson — Mon, 20 Aug 2018 13:47:46 GMT

I think this might do what you want

If( Is Missing( :Value ) == 0,
	Col Sum( If( :Value == 0, 1, :Value > 0, 0, . ), :SubGroup ) / Col Number( :Value, :SubGroup ),
)

Re: How to calculate zero portion in %

Thomas1 — Mon, 20 Aug 2018 13:57:44 GMT

Thanks again for yor fast reply.