Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to count values >=1 of column "C" excluding zero values. For example : The total values of column "C" is 9, but what I want to do is to count values>=1 which give me a result of 6.
I tried different scripts such as : Count(If({'TV OLED'} Display>=1,1,null()))
@bharathadde I find a solution Count(DISTINCT(if(Display> 0,Store)))
Try this
=Count({<Display={">0"}>}Display)
@bharathadde I find a solution Count(DISTINCT(if(Display> 0,Store)))