Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I need to get only the first value in the list

Hello:

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

Examplo:

pantalla.bmp

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

4 Replies
Clever_Anjos
Employee

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
Luminary Alumni

Hi,

Can you attach some sample, or try the following functions

=MaxString(DimensionName)

=MinString(DimensionName)

=FieldValue(DimensionName, N)

Regards,

jagan.

vijetas42
Specialist

Hi,

Try this expression,

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

Hope this will help you...

Regards,

Vijeta

Not applicable
Author

i think it can be possible in by first sorted value