ERROR

[ajsjoshua]

hi,

i am using this expression and i am getting the answer but a error line appears.

PFA

Regards,

Joshua.

[robert_mika]

Are you using your Dimension as Criteria?

I assume that may not work.

Could you post sample of this field data?

[ajsjoshua]

Hi,

PFA

Regards,

JOSHUA.

[ajsjoshua]

Hi,

some PBI's have 2 PKE's and I dont want it counted then.

If PBI's hav 2 PKE's only one should be counted.

[tamilarasu · Accepted solution]

Try,

=Count(Distinct {<[PBI STATUS]={'Completed'},PKE_ID -= {"PKE_ID****"}>}PBI_ID)

Update: Regarding the red error line.

This is a bug but you can see "Expression OK" in the expression window. I guess you are using older version and it's fixed in SR10 (Not sure).

[MayilVahanan]

Hi

Try like this

=Count(DISTINCT {<[PBI STATUS]={'Completed'},PKE_ID =-{"PKE_ID****"}>}PBI_ID)