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.

[arsal_90]

Hi Amalia could you please share the excel file because the data is coming in the load table is wrong

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

[srchilukoori]

I think there is an error in your cross table load. The Test field has same data as the Result. Take a look at it, that might help you with the logic.

[#4]

Please find excel and let me know.

[srchilukoori]

what are fileds 1A to 5E?

[#6]

Those are Error Types for each Member whether they Pass or Fail in doing the work. 1 denotes Fail and Blanks denotes Pass.

[MK_QSL]

Like this?

S20097 is coming two times. i.e under adm YY and Under adm ZZ

[#8]

Thanks. But the Test and Result are showing same values for most of the ones. Is it like that when we use CrossTable?

[MK_QSL]

Actually, I didn't understood your requirement properly.

[srchilukoori]

please go through the attached app for the updated cross table. You can transform further to reduce the number of records for 'Pass' records.

[arsal_90]

Hi Amelia

Please find the attached file.

please see cross table statement