Get value based on last date

[Former Member]

I have a report that takes 2 date parameters ("Start Date" and "End Date"). Get fields back based on that criteria....I want to create a formula field that shows me the "Amount" field data that is equal to the "End Date".

How can I do that?

Thanks in Advance!!

[Former Member]

Hi shaun,

You can take a running total of the date as

Running total name : datecount

Summary Field to Summarize as : yourdatefield

Type of summary : Nth largest

N is : 1

Evaluate

For Each Record

Reset

Never

Now Create a Formula for ur fileld as

if {Command.Yourdate} = {#datecount} then {Command.fieldname}

I hope this solves your problem

Regards,

Pradeep