Text Box - Value link to an expression

[Anonymous]

Hi

I need help with an expression in a text box.  Attached herewith is data relating to Calls and the date the Call was created.

I want an expression to tell me which is the oldest call?  The answer should be IR1086.  How do i do this? I have worked out the number of days the oldest call is, which is 197 days.

Please can you assist.

Kind regards

Nayan

[Frank_Hartmann]

try this:

date(num(today())-(max(today() - [Created Date])))

hope this helps

[Anil_Babu_Samineni]

May be use this?

=Only({<[Created Date] = {'$(=Max([Created Date]))'}>}Call)

[awhitfield]

Hi Nayan,

use the following:

=Only({<[Created Date] = {'$(=Min([Created Date]))'}>}Call)

as you are after the OLDEST date

HTH

Andy

[yoganantha321]

Hi Nayan,

As Andrew  mention use the following expression given by andrew:

=Only({<[Created Date] = {'$(=Min([Created Date]))'}>}Call)

It works perfectly

[stabben23]

Or by using Firstsortedvalue:

FirstSortedValue(Call,[Created Date],1)

[sunny_talwar]

May be this:

=FirstSortedValue(Call, [Created Date])

[Anonymous]

Hi All

Thank you for your reply.  It was helpful.  I have additional conditions ,where the

• "Service Level = "Active".
• Call Type = "Incidents"

See new data attached and the model.

How do I get the oldest Call number?

Kind regards

Nayan

[sunny_talwar]

May be this:

=FirstSortedValue({<[Call Type] = {'Incidents'}, Resolved_SLA = {'Active'}>}Call, [Created Date])

[sunny_talwar]

or this:

=Only({<[Created Date] = {'$(=Min([Created Date]))'}, [Call Type] = {'Incidents'}, Resolved_SLA = {'Active'}>}Call)