Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
add a stright table with all the fields which you have used and see which value is greater or less
Can you share an image of your data model?
here it is.
the field i am using are from one table only and need no connection with other tables.
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?
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!