Skip to Content
0

ranking variable not functioning properly when used with a prompt

Nov 30, 2017 at 02:38 PM

22

avatar image
Former Member

Hello all,

I'm in new to Business Objects. And I am building a report for a user who wants to look at the last Provider who attended a patient right before the patient was discharged. I created a ranking variable where rank 1 was given to the last attending date & time. Below is the screen shot of the results. Below screenshot 1 does not include Provider prompt. Therefore ranking is working perfectly and lets me filter out everything except rank 1. However the moment I filter on certain provider (in this case I look at the provider who provided services on the yellow highlighted date), all the patients that provider looked at irrespective of the ranking shows up. My question is can I do something at the WebI level to make sure my ranking doesn't change and only patients that show up for a provider selected in a prompt are ones where that provider was ranked. My second screen shot shows how the patient for whom the provider was ranked 4th shows up in that provider list and rank automatically changes to 1. Ranking formula I'm using is:

=Rank([End Date & Time];Top;([Patient Name]))

screenshot-1.jpg (67.9 kB)
screenshot-2.jpg (76.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

AMIT KUMAR
Nov 30, 2017 at 02:42 PM
0

what is your rank variable formula?

have you tried with adding Provider name in the rank formula as reset dimension?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 30, 2017 at 03:32 PM
0

Can you provide an example how do I do that?

Share
10 |10000 characters needed characters left characters exceeded
AMIT KUMAR
Nov 30, 2017 at 03:33 PM
0

try this.

=Rank([End Date & Time];Top)

Share
10 |10000 characters needed characters left characters exceeded