topic Re: Count if in App Development

Count if

ptl14495 — Mon, 02 Apr 2018 10:31:33 GMT

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

Re: Count if

sunny_talwar — Mon, 02 Apr 2018 11:33:13 GMT

May be this

Count({<[Order No] = {"=[Actual Response Time] > [Contractual Response time]"}>} [Order No])

Re: Count if

sunny_talwar — Mon, 02 Apr 2018 11:33:49 GMT

Alternatively, you can use an if statement

Count(If([Actual Response Time] > [Contractual Response time], [Order No]))

Re: Count if

ptl14495 — Mon, 02 Apr 2018 11:38:56 GMT

Hi,

the formulas has some error. It can't be aplied.

I have tried to reposition the " and {} but with no success.

Can you help please?

thank you

Re: Count if

sunny_talwar — Mon, 02 Apr 2018 11:40:30 GMT

Where exactly are you trying to use this? Can you show an image of the error that you are seeing?

Re: Count if

ptl14495 — Mon, 02 Apr 2018 11:42:33 GMT

Re: Count if

sunny_talwar — Mon, 02 Apr 2018 11:47:19 GMT

I see no error, this expression gives 0 as result?

Re: Count if

ptl14495 — Mon, 02 Apr 2018 11:59:56 GMT

the result is the count of all order no.

Re: Count if

sunny_talwar — Mon, 02 Apr 2018 12:03:23 GMT

Did you try this?

Count(If([Actual Response Time] > [Contractual Response time], [Order No]))

Re: Count if

ptl14495 — Mon, 02 Apr 2018 13:28:07 GMT

Re: Count if

ptl14495 — Mon, 02 Apr 2018 13:29:05 GMT

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

Re: Count if

Chanty4u — Mon, 02 Apr 2018 13:29:36 GMT

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

Re: Count if

sunny_talwar — Mon, 02 Apr 2018 13:30:34 GMT

Can you share an image of your data model?

Re: Count if

ptl14495 — Mon, 02 Apr 2018 14:09:11 GMT

here it is.

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

Re: Count if

sunny_talwar — Mon, 02 Apr 2018 14:12:11 GMT

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?

Re: Count if

ptl14495 — Mon, 02 Apr 2018 14:17:42 GMT

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!