Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have an Order Number (OOT), which can have multiple different Order Statuses' during the Order Process.
There are 3 different status'. ie. In Progress ; Completed ; Finalised
I essentially want to get a count of the most up to date Status, that Order Number has. I'm thinking about a Max.
So, I'd like a text box with the Count of 'In Progress' Orders.
then a Count of 'Completed' Orders and finally a Count of 'Withdrawn' Orders.
In my attached example, this Order Number would have a Order Status of 'Finalised', as that is the Latest Update of Status. and the other's would be ignored
So, I'd just want to count this Order number, with Order Status of 'Finalised'
Any ideas would be greatly appreciated.
Cheers!
Try using the firstsortedvalue function:
FirstSortedValue([Order Status], -LAST_UPDATE_DATE)
Use the function FirstSortedValue()
See the manuel for more info.
/Jesper
Try using the firstsortedvalue function:
FirstSortedValue([Order Status], -LAST_UPDATE_DATE)
Hi Gysbert,
It works perfectly if I put it in a table, but I'd like to i put it in a text box, on a dash-board.
It give a value of '0' if I use the same expression in a text-box.