BEx conditions with interval not working

[Former Member]

Hi experts

We have designed a BEx query conditions on a formula "NODIM" which should only show the records in an intervall.

The interval variable "from" and "to" are defined with dimension setting "number":

The condition is defined with between as operator:

If you enter an intervall, e.g. 1 to 1.500 it gives you one record, although there are much more records in this interval.

Any ideas?

Thanks

T.

[BernhardE · Accepted solution]

Hi Thomas,

Do you have multiple characteristics in the drilldown?

If yes, you should check whether you have defined the condition to be applied according to the characteristics in drilldown or whether you have defined it as "All characteristic in Drilldown Independently".

In the later case the condition is applied - as its name implies - on all characteristis in the drilldown independently. So you need to also take into account the result line values to see how the condition is working.

http://help.sap.com/saphelp_nw74/helpdata/en/1e/7875a998bc44409f6002e28552685a/content.htm?frameset=...

-> see Rule 9

In order to evaluate the condition for characteristics or characteristic combinations defined for specific drilldowns only you can use setting "Single Characteristics and Characteristic Combinations".

Maybe this helps.

BR Bernhard

[Former Member · Accepted solution]

fixed.

Rule 4 and 5 worked for the previous "solution".

Now we have set posting document (Belegnummer) as determining char for the condition.

It works as required.

[former_member220624]

Hi Thomas,

What are the settings for variable 'from' and 'to'

Also give a try with two conditions. One with greater than 'from' variable and other with less than 'to' variable.

Regards,

Amit

[Former Member]

Hi Amit

Please check the most relevant properties, they are equal for both "from" and "to"....

[former_member220624]

Hi Thomas,

Thanks for the screenshots.

Can you try with two different conditions as opposed to using 'between' operator and share the results with us.

Regards,

Amit

[Former Member]

I have already tried this, also ignoring these conditions:

Definition of "greater" and "less":

[former_member220624]

Hi Thomas,

That's unfortunate. Please try running the query in RSRT in debug mode to identify where it is going wqrong.

Also i see these are formula variables. Can you include these formula variables in two selections in columns and see what values they fetch when we run the report.

Regards,

Amit