Showing results for 
Search instead for 
Did you mean: 

Giving out a variable for a key figure

Former Member
0 Kudos


I want to have a variable for a number, a variable entry of query output screen. Can I do that?

Heres the exact description of the requirement.

I have got a key figure in a query.

Now I want to return a value 1 if >X and 0 if value <X.

So can i have a variable for this X, to be eneterd by user.

Please revert for any clarification in this regard.

Thanks in advance.



Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Naveen,

create a new calculated key figure. Within this key figure, you create a formular variable X of type user entry. The formular for the key figure will just be:

Query Key Figure > X

You can find the > in the formular editor under Boolean Operators (is greater than).

May be you need a NODIM operation around your Key Figure to get rid of units.

The result is 1 if KeyFigure > X and 0 if Key Figure <= X.

Hope that helps


Answers (0)