This content has been marked as final.
Show 2 replies
-
1. Re: Counting items different to zero
John Sobczak Jan 25, 2018 5:25 AM (in response to Ed Yeldham)2 of 2 people found this helpfulCountD(if [sales] <> 0 then [Product Code] end)
-
2. Re: Counting items different to zero
Zhouyi ZhangJan 25, 2018 4:09 AM (in response to Ed Yeldham)
1 of 1 people found this helpfulHi, Ed
Not seeing your sample workbook, but if you could try below calculation instead of countd([product code])
Countd(
if [sales value] > 0 then
[product code]
end
)
Hope this could help