expression to compare two results in the same field

[baderbd]

I have a field (Delivered on Time) that reports either "Delivered On Time" or "Delivered Late"  I tried to do a few expressions, but Qlik did not accept them, and cannot figure out what I am missing.  It tells me I am missing a ")" but I could not tell where.

[kaushiknsolanki]

Share the expression you have used for a better understanding of your problem.

[baderbd]

Thanks for answering.  I have been trying constantly.  I am now on this expression

Count(distinct [Delivered On Time]) / count([Delivered On Time] = "Delivered On Time")

Basically I need to show the percentage of the amount of times the delivered on time field returns delivered on time.

[chayeneg · Accepted solution]

Count({<[Delivered On Time] = {'Delivered On Time'}>}[Delivered On Time] )

/

Count([Delivered On Time])

[baderbd]

Thanks I tried this but the math did not work.

[chayeneg]

Can you explain why the math didn't work?
Do you have the total count of the 'delivered on time' field and the total count of the 'delivered on time' field is 'delivered on time' to share?

[baderbd]

Hey I must have goofed bringing in the expression, it totally works.