Count if Count functionality

[sivarajs]

Hi,

I have a situation like i need to count then i ahve to use same for condition as well

e.g

count(A)

count(if(count(A)>1,A))

But is not working and i dont want to do it in script

-Sivaraj

[#2 · Accepted solution]

Hi Siva,

Did you use this?

count(if(column1>1,A))

Regards,

Amay

[alexandros17]

You can do:

if(count(A)>1,count(A),'Not Available')

if you want a value you can set your value instead of  'Not Available'

Hope it helps

[sivarajs]

Hey Amay i have tried the same and i got it but i dint notice that i have got