Range on Keyfigure as a variable

[former_member327592]

Hi,

Can you please help me .

I have a requirement in the report to create a variable to enter range on key figure .

Say for eg . Purchasing total amount in the selection , user may enter range of amount from 0 to 1000 to give list of purchase orders that falls with in that range .

I have managed to use variable as a single value using condition . so It has ended up as two selections as attached in the screen print .

Is there any way to use range on this amount key figure to appear as an interval variable ?

Appreciate your input.

Thanks

[former_member274922 · Accepted solution]

Hi Manoj,

under the following links you can find some information about the topic:

OT-OLAP Filter Values - Restricting Characteristcs
https://wiki.scn.sap.com/wiki/x/A4BEEg

OT-OLAP-VAR Variables
https://wiki.scn.sap.com/wiki/x/MIBEEg

Regards,
Matthias

[kohesco]

Hi,

No you did a great job 😉

you can use: between in your condition but it will generate also 2 input screens, but I guess, that shouldn't be any problem