I need to get only the first value in the list

[#1]

Hello:

I need to get only the first value in the list:

Examplo:

I have a set of records which are repeated, I need to get only the first value in the list:

If(escoger2 ='Emp. Que No Se Le Pagaron Vacaciones',

  FirstSortedValue

(HisPagAnoPro = '2014' and ProNomCod = 1 and HisPagFlgRev <>'R', EmpCod),

Helpme

Please

[Clever_Anjos]

FirstSortedValue expects two parameters,

1) The expression to be sorted

2) The rank order

Maybe

FirstSortedValue(EmpCod,[Some Sorting Expression]) can calculate what you want

[jagan]

Hi,

Can you attach some sample, or try the following functions

=MaxString(DimensionName)

=MinString(DimensionName)

=FieldValue(DimensionName, N)

Regards,

jagan.

[vijetas42]

Hi,

Try this expression,

=FieldValue('Dimension/Field Name',1)

Hope this will help you...

Regards,

Vijeta

[#5]

i think it can be possible in by first sorted value