cancel
Showing results for 
Search instead for 
Did you mean: 

Question: How to use Rank on date?

0 Kudos

Hi Expert,

Need your help!

Question: How to use Rank on date?

I need to populate one liner for payment id and as per users request it should be on the maximum date of “Recurring Payment Start Date”. I am bit confused to find out the maximum date from “Recurring Payment Start Date”.

How to use Rank function on date ? Please help

I am using BO Xi 3.0

Thanks

Sam

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Sam,

You can achieve the desired ouput even without using RANK function.

create a variable with the below formula

Max Date  = [Recurring payment Start Date]Where([Recurring payment Start Date]=(Max([Recurring payment Start Date])In([Payment ID])))

Use Max Date in place of Recurring payment Start Date column.

And create a filter on the table on Max date with the condition Max date is not null.

You will get the expected output.

Cheers

Sri Harsha

0 Kudos

Hi Sri Harsha,

Sorry for replying you very late!

your advice worked. You are awesome.

Thank you soooooo much.

Thanks

Sam

Answers (1)

Answers (1)

former_member196948
Participant
0 Kudos

Hi Sam,

Try below step

Create variable called rank : =Rank([Recurring Payment Start Date])

and then

Date : =[Recurring Payment Start Date] Where ([rank] = 1)

Hope it will work..

Regards,

Jeet