5 Replies Latest reply: Apr 23, 2014 4:51 AM by Dariusz Mielczarek

# FirstSortedValue with double values

Hi,

Who can help me solving this problem.

I'm using a script to select the value of the lowest Koers and the highest Koers

It works correct as long there are no double Koers values

If there is a double Value I want to select the latest date.

DateMaxKoers

FirstSortedValue(Date, -Koers) AS DateMaxKoers

Resident Koersen;

FirstSortedValue(Date, Koers) AS DateMinKoers

Resident Koersen;

I expect    as DateMaxKoers      16-04-2014     11,95

as DateMinKoers        14-04-2014     11,75

 Date Koers 17-04-2014 11,91 16-04-2014 11,95 15-04-2014 11,84 14-04-2014 11,75 11-04-2014 11,83 10-04-2014 11,76 09-04-2014 11,77 08-04-2014 11,75 07-04-2014 11,94

Thanks for thinking with me.

• ###### Re: FirstSortedValue with double values

Try using distinct like:

FirstSortedValue( Distinct Date, Koers) AS DateMinKoers

Don't worry about syntax error red mark.

• ###### Re: FirstSortedValue with double values

Treseco,

Using Distinct gives me a value, but it is the first date (08-04-2014) in stead of the last date (14-04-2014)

Gr. Richard

• ###### Re: FirstSortedValue with double values

User the Order By clause to change the order of load , like:

Temp:

Date,     Koers
17-04-2014, 11.91
16-04-2014, 11.95
15-04-2014, 11.84
14-04-2014, 11.75
11-04-2014, 11.83
10-04-2014, 11.76
09-04-2014, 11.77
08-04-2014, 11.75
07-04-2014, 11.94
];
Fin:
FirstSortedValue(distinct Date, Koers) as FSV
Resident Temp order by Date asc;

• ###### Re: FirstSortedValue with double values

Treseco,

When I use Order by Date desc I got what I expect.

Gr. Richard

The complete script:

FirstSortedValue(Date, Koers) AS DateMinKoers

Resident Koersen

Order by Date desc;

• ###### Re: FirstSortedValue with double values

Example for you with calculations in the script and on the fly.

Regards

Darek