Order of items email report

Hi,

I have a report that sends an email and orders driver delivery drops by number. Each delivery is assigned a number from 1 onwards.

The order comes out fine until it gets to number “10” which it places after “1” rather than “9”. I have changed the order numbers to 10, 20 , 30 etc and still the same result. 100 comes after 10.7

Expression is

<<Start:Orderby(Running Sheet 24[Outlet No],[Running Sheet Report Calc],FALSE)>>

Any ideas why? Pic attached

thanks

Phil

Is [Running Sheet Report Calc] set to a column type of number?

1 Like

Hi Simon, Yes it’s set to Number

Would SORT() work better? I couldn’t work out how to write the expression.

thanks

Phil

Hi, Sorry

It is set to list. It is a virtual column with this expression

SELECT(Orders[User Stop],AND([Outlet No]=[_THISROW].[Outlet No],IN([Delivery Date],Running Sheet 2[Delivery Date]),OR([Order Status]=“Open”,[Order Status]=“Exported To Xero”,[Order Status]=“Open (Unarchived)”)),IN([Route],Running Sheet 2[Route]))

If I change it to number - how do I cange the expression to get the corrrect result as in number from the expression above

thanks

Phil

Wrap the SELECT() expression in ANY(), then make sure the column type is Number.

That worked

thank you

phil

1 Like