Error in Expression

[Anonymous]

Can anyone assist with tracing the error in the following expression:

Count(DISTINCT({<[Doctor Name]={'PIM'}>}[Script Number])) + Count(DISTINCT({<[Doctor Name]={'PID'}>}[Script Number]))

Regards

[#2]

Change like this.

=Count  (distinct {<[Doctor Name]={'PIM'}>}[Script Number]) + Count( distinct {<[Doctor Name]={'PID'}>}[Script Number])

"Distinct" is not a function.

[Anonymous]

you have extra brackets: no brackets necessary after distinct...try this

Count(DISTINCT {<[Doctor Name]={'PIM'}>}[Script Number]) + Count(DISTINCT {<[Doctor Name]={'PID'}>}[Script Number]))

[rwunderlich · Accepted solution]

I would say that Set expression comes before the DISTINCT keyword like this:

Count({<[Doctor Name]={'PIM'}>} DISTINCT [Script Number]) + Count({<[Doctor Name]={'PID'}>} DISTINCT [Script Number])

-Rob

[Anonymous]

Hi Rob

Many thanks, you are right, that works.

Regards.

Chris

[Anonymous]

Many thanks, I used Rob's recommendations.

[Anonymous]

Many thanks.  I used Rob's recommendations