Count if with < *error*

[Daryn]

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

[MayilVahanan]

HI

Try like below

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

[Daryn]

Hi Mayil,

Many thanks for replying.

Unfortunately still shows as an error.

[MayilVahanan]

Hi

Try like below

LFART ={'XLR', 'XLS'}

[Daryn]

Thank you again Mayil, but still same error.

[MayilVahanan · Accepted solution]

Hi

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

[MayilVahanan]

Can u attach the sample file?

[Daryn]

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