topic Counting Multiple condition in App Development

Counting Multiple condition

Anonymous — Tue, 22 May 2018 02:46:45 GMT

Hi,

I have a column called Order status which has "OK", "NOK' and "-" as different status. I want to count total orders enslaved and total orders not enslaved.

For enslaved I want the count of "OK" and "-" whereas for Not Enslaved I want the count of "NOK"

I am using the below expression but it is giving me wrong results.

='Enslaved:'&' '& count({<OrderStatus={'OK'},OrderStatus={''}>}OrderStatus) & chr(10) &

'Not Enslaved:' & ' ' & count({<OrderStatus={'NOK'}>}OrderStatus)

Could anyone please help me with this urgently?

Re: Counting Multiple condition

giovanneb — Tue, 22 May 2018 18:14:22 GMT

Hello, I suggest reviewing the data treatment because the value "-" messes up the set analysis, follows example

Best Regards

Re: Counting Multiple condition

rubenmarin — Tue, 22 May 2018 18:26:58 GMT

Hi Akash, each field can be only applied once in sdet analysis and there are 2 OrderStatus, multiple values can be assigned separated by commas:

='Enslaved:'&' '& count({<OrderStatus={'OK','-'}>}OrderStatus) & chr(10) &

'Not Enslaved:' & ' ' & count({<OrderStatus={'NOK'}>}OrderStatus)

Also null() is not a selectable value, maybe with:

='Enslaved:'&' '& (count({<OrderStatus={'OK'}>}OrderStatus)+NullCount(OrderStatus)) & chr(10) &

'Not Enslaved:' & ' ' & count({<OrderStatus={'NOK'}>}OrderStatus)

Or, if you have a field in the same table that always have a value to count:

='Enslaved:'&' '& count({<OrderStatus-={'NOK'}>}OtherField) & chr(10) &

'Not Enslaved:' & ' ' & count({<OrderStatus={'NOK'}>}OrderStatus)