topic Re: Count if with < error in App Development

Count if with < error

Daryn — Mon, 23 May 2022 08:53:02 GMT

Hi all,

I hope you are all well and thanks in advance for reading and hopefully assisting with my query.

I am trying to use the below;

count ({< [WADAT_IST] < [WADAT], LFART = '{XLR, XLS}' >} VBELN ) / COUNT (VBELN)

In a bar chart. WADAT and WADAT_IST are two date fields. I want to compare them (the above would be deemed 'early' as it was issued before planned so using the < operator. But it wont allow it, giving me an 'Error in expression'. It will only allow =

The LFART is a type of deliver I am filtering for and then VBELN is document. These are all standard SAP fields.

Why is this please and what should I have as the expression?

I will then also have two others (hopefully) using = (for on time) and > for late.

I hope that makes sense.

Kind regards,

Daryn

Re: Count if with < error

MayilVahanan — Mon, 23 May 2022 09:48:21 GMT

Try like below

count ({< [WADAT_IST] {"=[WADAT_IST] < [WADAT]"}, LFART = '{XLR, XLS}' >} VBELN ) / COUNT (VBELN)

Re: Count if with < error

Daryn — Mon, 23 May 2022 10:02:28 GMT

Hi Mayil,

Many thanks for replying.

Unfortunately still shows as an error.

Re: Count if with < error

MayilVahanan — Mon, 23 May 2022 10:34:44 GMT

Try like below

LFART ={'XLR', 'XLS'}

Re: Count if with < error

Daryn — Mon, 23 May 2022 10:42:41 GMT

Thank you again Mayil, but still same error.

Re: Count if with < error

MayilVahanan — Mon, 23 May 2022 10:58:53 GMT

[WADAT_IST] = {"=[WADAT_IST] < [WADAT]"}

Re: Count if with < error

MayilVahanan — Mon, 23 May 2022 10:59:09 GMT

Can u attach the sample file?

Re: Count if with < error

Daryn — Mon, 23 May 2022 11:26:53 GMT

Hi Mayil,

That fixed the error in the expression, thank you. 👍

Working as:

count ({< [WADAT_IST] = {"=[WADAT_IST] < [WADAT]"}, LFART ={'XLR', 'XLS'} >} VBELN ) / COUNT (VBELN)

Much appreciated.

Regards, Daryn

topic Re: Count if with < *error* in App Development

Count if with < *error*

Re: Count if with < *error*

Re: Count if with < *error*

Re: Count if with < *error*

Re: Count if with < *error*

Re: Count if with < *error*

Re: Count if with < *error*

Re: Count if with < *error*

topic Re: Count if with < error in App Development

Count if with < error

Re: Count if with < error

Re: Count if with < error

Re: Count if with < error

Re: Count if with < error

Re: Count if with < error

Re: Count if with < error

Re: Count if with < error