Order of items email report

[Phil_Waite]

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

[1minManager]

Phil_Waite:

[Running Sheet Report Calc]

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

[Phil_Waite]

Hi Simon, Yes it’s set to Number

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

thanks

Phil

[Phil_Waite]

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

[Steve · Accepted solution]

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

[Phil_Waite]

That worked

thank you

phil