Oldest Outstanding order

[ccsimo16]

Hi

I can report on my outstanding order with no problem, but i am struggling with reports the oldest outstanding order only. Can anyone help?

Thanks

Chris

[Clever_Anjos]

Which criteria you use to classify an order as "outstanding"?

[tresesco]

You may probably use firstsortedvalue() for the same. We could better help if you could provide a sample data set and explain the expected output.

[ccsimo16]

Hi

I use express =if outstanding >0, sum(outstanding),'')

this will display all my outstanding

thanks

Chris

[Chanty4u]

i think  u can use Firstsortedvalue(field,-dim)

if you want fixed values you can define the range

Firstsortedvalue(field,-dim,3)

[Clever_Anjos · Accepted solution]

Maybe this, please adjust your field names

FirstSortedValue({<outstanding={">0"}>}OrderNum,Date)

[ccsimo16]

Thank you to everyone, what a great community