How to calculate zero portion in %

[#1]

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.

[#2]

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

[#3]

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.

[#4 · Accepted solution]

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 ),
)

[#5]

Thanks again for yor fast reply.