SageForum for UK versions of Sage 50- Help and support.

I'd tried that but it wouldn't return 0 if non-blank and not numeric ie something like ABC in the field also. It failed with an error.
I assume that test only works if there's a numeric value or nothing.

I'm on v29 btw

Thanks Bruce

I ended up with 2 Expressions

Expr3 = Length(PURCHASE_ORDER.ANALYSIS_1) <> 0 ? Substring(PURCHASE_ORDER.ANALYSIS_1,0,1):"-"

Expr2 = Expr3 <> "-" ? Expr3 <= "9" ? StringToInteger(PURCHASE_ORDER.ANALYSIS_1) : 0 :0

Could I have done this more efficiently ?

Hi
Is there any way in RW you can test a field for numeric values ?
A PO analysis field is being used under certain circumstances for a numeric identifier but can also be text or blank.
I've got a check based on length of the field <> 0 to see if it has any data in it but if it's numeric I'd like ...

Feel free to move this question to the correct section.

I'm trying to accumulate actual material costs for a project to give me a one line actual v budget report .but cant fathom out where that data comes from when you look at the Project Activity screen. Any help gratefully received

I just about understand what Sections are all about but I don't understand using them within an existing section. (They seem to need some form of grouping which I don't really need and I wouldnt know where to start as I only need the Despatch Note in the default order for invoices).

I think I'll ...

I have a similar issue trying to print despatch notes from invoice data. I would like to print the BOM where a product has one and suppress the printing when it doesnt.
I can almost do it but get a lot of blank lines because a line of underscores remains even though I'm using the same criteria to ...