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.

[srchilukoori]

can you attach a screenshot of the error please.

[#3]

Please find attached qvw and excel. please help me.

EDIT: if you see there are no fails for some columns but still showing fail count.

for eg: for 1B,1C,1D there are no fails but still showing fail count in Error Code Straight table. That' sthe problem I am facing.

[#4]

I need to show how many reports were reviewed, failures and % of failures by Member

and how many reports were reviewed, failures and % of failures by Error Code.

[srchilukoori]

"for eg: for 1B,1C,1D there are no fails but still showing fail count in Error Code Straight table. "

You are counting the Record IDs for the 1B, 1C ...., you need to sum the Error Flags to see the total of 1B errors.

[srchilukoori]

Check the attached application for the Failure Count by error code.

[#7]

Thanks. for me it the Fail counti showing 81. Please see attached.

[srchilukoori · Accepted solution]

I think the error is in the script.

after enclosing the fields 1E, 2E... in square brackets, the results are displayed correctly.

[#9]

Thanks. That's perfect!