on 09-10-2015 12:52 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.