hi All,
We've got a business requirements of having 24 different rate columns in BEx which the customer requires to rank all these 24 data columns. We first added 24 conditions for these 24 data columns respectively, but find no any data coming out when running the query. Then we delete 23 conditions and leave only 1 condition and the query runs with results, but you know this only makes 1 data column ranked other than other 23 data columns. We heard there could be some ways of using some logic, e.g., OR or AND to link these conditions together to fulfill the requirements to rank all the 24 data columns, but have no idea how to do it. Anyone could give us a step by step procedure?
We will give you rewards points for valuable answers.
Thanks!
Kevin
hi Suman,
We have used the formula "column A data" %a "Column B data" to get the percentage number already. As we said, we can only use 1 condition for one formula column, if apply 24 conditions for all these 24 formula columns which shows percentage numbers, then no data comes out when running query. Not sure you say 'apply conditions on all KFs < the maximum value', what does it mean? Could you elaborate it?
Thanks!
Kevin
Hi,
If you are referring to OR and AND condition then if you make different conditions inside a single condition then it may work on OR logic.
In case you make separate list of conditions then it may work with AND logic.
Hope this is what you are looking for,if not then please explain with some example.
Regards,
AL
Try with "Calculate Single Value as" Rank Number for all 24 KFs in the query designer. This setting will be in "Calculations" tab in Bex.
If you apply condition on your Kfs, all your data will come in descending order which will not suffice your requirement.
Add a comment