on 11-24-2015 6:42 AM
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.
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.
-> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
80 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.