Load data from CSV and Set analysis

[#1]

Hello,

I am trying to load data from excel and i have written the set analysis expression as below:

Launched Qty = count of trackingID along with selected criteria and breakage description is null

Rejected Qty = cout of trackingID with selected breakage description or (all breakage description except null)

reject rate = RejectedQty/Launched Qty.

PFA the excel data, and the QVW file.

The same expressions work well if I save the datafile as CSV. Why are the expresssions not working with excel data.

Kindly help me

Thanks,

Deepa V