Problems with fieldvalue

[jorgelardi]

Hi,

Fieldvalue ('Field', n) where n is the number of the row but the number of occurrence of that value without repetition.

Question: How can I identify the value of a field in a row number specific recital repetitions?

Thanks

[sunny_talwar]

Not sure I understand your question. Would you be able to elaborate?

[jorgelardi]

Example:

Date        -       Stocks

1/1/2016  -          56

2/1/2016  -          58

3/1/2016  -          58

4/1/2016  -          54

5/1/2016  -          54

.......

31/1/2016 -         58

I want to build two text object that, when I select the month of January in a list box in one of them I show the stock of day 1 and another of them show me the stock of the day 31.

I tried to resolve it with fieldvalue but the problem is that the stock of day 2 coincides with the day 3 and day 31.

So I want to try to solve it with fieldvalue or other resource

Thank you

[sunny_talwar · Accepted solution]

Try this:

For stock on Jan 1st

FirstSortedValue(Stocks, Date)

For stock on Jan 31st

FirstSortedValue(Stocks, -Date)

[jorgelardi]

Wonderful !!!

Thank you Sunny T

[sunny_talwar]

No problem, I am glad I was able to help