Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Question: How to use Rank on date?

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

1234.jpg (99065 B)
replied

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

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question