Count if

[ptl14495]

Hi,

I have a table with two fields i want to use as a condition to count the number of orders that fulfill that condition.

Something like,

If ( Actual Response Time > Contractual Response time, Count ( Order No ), if not don't count )

I am not confortable doing it in script so i need a solution if possible, as an expression.

thank you

Fernando Rodrigues

[ptl14495]

that is what i see. meanning, i have the same result with the formulas  (the count of order is just for you to have an idea of the total)

thank you

[Chanty4u]

add a stright table with all the fields which you have used and see which value is greater or less

[sunny_talwar]

Can you share an image of your data model?

[ptl14495]

here it is.

the field i am using are from one table only and need no connection with other tables.

[sunny_talwar · Accepted solution]

Oh so they all come from the same table? Is it possible that all Order No_ meet the condition? Can you check this by creating a table like this

Dimensions

Order No_

Actual Response Time (Hours)

Response Time

Measure

[Actual Response Time (Hours)] > [Response Time]

and see if you are seeing  any 0s or not?

[ptl14495]

You're absolutely right!

i was connecting the wrong field!

I'll get back on this if i get no luck with any of your suggestions.

My apologies.

thank you!