Where go wrong on this expression = COUNT(if(Month_n=1,DISTINCT(Invoic)))

[paulyeo11]

Hi All

I need to add Month_n=1 into below expression :-

COUNT(DISTINCT(Invoic))

I have try :-

COUNT(if(Month_n=1,DISTINCT(Invoic)))

it cannot work .

Paul

[dplr-rn · Accepted solution]

use set analysis where you can like belo

COUNT(DISTINCT {<Month_n={1}>}Invoic)