Firstsortedvalue issue with date

[Somasundaram]

Hi All,

I am facing the issue with Firstsortedvalue function. attached screenshot,

Two date having same values, but i need the max date of the two dates,

=DATE(FirstSortedValue( DISTINCT DATE,-AMOUNT,'MM/DD/YYYY').

If using this expression, it gives 12/28/2015. But i want to show 12/29/2015.

Pls. suggest.

Thanks in advance,

Somasundaram 

[tresesco]

You can try adding date field with the amount filed, like:

=DATE(FirstSortedValue( DISTINCT DATE,-AMOUNT-DATE,'MM/DD/YYYY')

If your date field is really a date field (number the the back-end), this should work.

[Somasundaram]

Thank for your reply.

If i am using with date value, i am getting  maximum date value.

not showing the correct values

[tresesco]

Could you share your sample app?

[tresesco]

Do you need only those two columns or you have something else as dimension?

[Somasundaram]

I need date values based on the max amount.
Provide the both scenarios.
Thanks tresesco.

[Somasundaram · Accepted solution]

Using this expression I can able to get the correct value
=DATE(DISTINCT FirstSortedValue(DATE,-(AMOUNT+DATE*0.0001)),'MM/DD/YYYY')

[tresesco]

Great. So you can close the thread by marking correct/helpful replies.