I'm trying to check if the result of a Select has any item or returns 0 items.
IF(AVERAGE(SELECT(@April,P:P; * 0.01, @April,K:K; = "1%")) !=BLANK(), AVERAGE(SELECT@April,P:P; * 0.01, @April,K:K; = "1%"), 0)
If the Average function returns no item with my condition, I want to return "0" value.
But I don't know how to compare the result in order to know if there are items or not. IF functions ALWAYS returns me 0 items,
Anybody knows how to get this working?
Thanks in advance