Help in expression as the expression is not working?

[#1]

Hi,

I have Straight table. The data is coming from excel sheet.

Dimension: Member

Expressions are

Number: Count(Distinct(ID))

Fail: count({<[Result]={'Fail'}>}Distinct ID)

When I am using the second expression(Fail) the values are showing zeroes eventhough the excel sheet contains data for fail. Please can anayone help me.

Thanks.

[#2]

Please find attached.

EDIT: In excel sheet the overall result contains Pass and Fail. But the values in the Result contains '1' and 'Blanks'

Here '1' means fail and 'Blamkns' means pass.

[srchilukoori]

You are using a wrong field. You need to use Overall Result = Fail

[its_anandrjs]

Check your expression like

count(Distinct {< [Result] = {'Fail'} >} ID)

Hope this helps

[#5]

Yes you are right. I tried that already. I have a doubt here if I use Overall Result will I get correct values for below?

Noof Reports Reviewed, No of Failures, % of Failures for Member and for Test?

[its_anandrjs]

You have to use

count(DISTINCT {<[Overall Result] = {'Fail'}>} ID)

Hope this helps

Thanks & Regards

[SunilChauhan]

use [Overall Result] inplace

you r using wrong field thats why its showing zero

count({<[Overall Result]={'Fail'}>}Distinct ID)

[srchilukoori]

I don't follow the question about the No.of Reports reviewed...

I don't see any such fields in the app.

[#9]

sorry. It is Numebr, Fail and % of Fail.

Will I get the correct values for above?

[#10]

Thanks. It's working.

EDIT: I suppose I have mistaken as I thought the data in crosstabel is correct. Please help me as I attached excel and let me know how to sort this?