Skip to Content
avatar image
Former Member

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 (99.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 10, 2015 at 11:42 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 10, 2015 at 12:12 PM

    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

    Add comment
    10|10000 characters needed characters exceeded