Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I want to count how many create note ?
I have already have 2 create note , field name = sales_88
I assume the expression should look some thing like below :-
count(distinct(if(sales_88=1,[AR Invoice Number])))
But it display zero value.
Hope some can share with me how to make it display 2 ?
Paul Yeo
There is no value of 1 within sales_88 so I think you need to check your source-data.
- Marcus
Hi,
I think you want to count if sales_88 = AR Invoice Number, so use
count(distinct(if(sales_88=[AR Invoice Number],[AR Invoice Number])))
Regards
Hi All
Enclosed my QVW
There is no value of 1 within sales_88 so I think you need to check your source-data.
- Marcus
Hi,
I think you want to count if sales_88 = AR Invoice Number, so use
count(distinct(if(sales_88=[AR Invoice Number],[AR Invoice Number])))
Regards
Hi Sir
Your expression is right. also because you have spotted 2 credit note.
=count( {< Year_n={1}, inv ={"=sales_88"}>} distinct inv)
Above is another solution i figure out.
Thank you very much
Paul