Why do I get an error while finding the following Distinct Count ?

[#1]

I am using this expression to find the distinct count :

" count(distinct[Invoice Number]) "

Where Invoice Number is the Field Name .

Help Me out .

[arasantorule · Accepted solution]

Please use count(distinct([Invoice Number]))

bracket after distinct

Thanks

[simospa]

Hi,

in first, look at the space between distinct and [

count(distinct [Invoice Number])

Then ensure that [Invoice Number] really have I and N uppercase.

Let us know.

S.

[simospa]

Ankit: I see you are a Novice.

I remember you to mark correct an answer if it provide you a solution to your issue.

Thanks

S.

[Kushal_Chawda]

Try,

count(distinct [Invoice Number])

[#6]

Thanks a Lot This worked

[simospa]

Then mark as "correct answer" the answer. It might help others in the future 🙂

S.