
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I need to get only the first value in the list
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Can you attach some sample, or try the following functions
=MaxString(DimensionName)
=MinString(DimensionName)
=FieldValue(DimensionName, N)
Regards,
jagan.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Try this expression,
=FieldValue('Dimension/Field Name',1)
Hope this will help you...
Regards,
Vijeta

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
i think it can be possible in by first sorted value
