1 Reply Latest reply on Mar 16, 2014 12:53 PM by GuyStevens

Max formula

vadleft@gmail.com Mar 16, 2014 9:23 AM

Title

Max formula

Post

Need to find the dollar value of an entry that is related to the most current date in an array of dates.

I thought I could use an "If " formula by finding the max in the date column and then the corresponding dollar amount. Just can't seem to get it together.

Any ideas?

1. Re: Max formula

GuyStevens Mar 16, 2014 12:53 PM (in response to vadleft@gmail.com)

You can sort your relationship so that the most recent date is sorted on top. Then if you get the value in the "Dollar Value" field form that related table it will get the most recent one.
Like Show 0 Likes(0)

Actions