cancel
Showing results for 
Search instead for 
Did you mean: 

Performing ranking calculations with the BEx Query Designer - ideas?

Former Member
0 Kudos

I have a scenario where I have a key figure with raw values. In the column beside this I want to rank the key figures by their raw values.

Something like this:

Amount Rank

0.11 2

0.05 3

0.22 1

0.03 4

I can do this no problem using the "Calculate Single Values as:" Ranked List.

For subsequent calculations I need to perform mathematical operations on the RANK column. For example say I want to make a 3rd column where I divide the rank by 2:

Amount Rank Rank by 2

0.11 2 1

0.05 3 1.5

0.22 1 0.5

0.03 4 2

I cannot figure out how to do this as SAP does not really STORE the values of the rank column for my next calculation. The "Rank by 2" column actually shows this:

Rank by 2

0.065

0.0025

0.11

0.015

which is dividing the original amount by 2 and not the actual RANK value.

Anyone have some suggestions on what I can do?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I know what you are talking about, it will always return 1 or zero which is true or false, I don't think you can do anything much to this. Since, the value of Ranked is getting calculated at runtime.

thanks.

Wond