Search found 3 matches

by Barlow81
21 Jan 2022, 12:07
Forum: Sage 50 UK version General Help
Topic: Expression to only include information in report
Replies: 4
Views: 5678

Re: Expression to only include information in report

Thank you for your reply. I think i have now solved this using the expression....

Startswith(PROJECT_COST_CODE.REFERENCE,"ELEC20")
by Barlow81
20 Jan 2022, 15:47
Forum: Sage 50 UK version General Help
Topic: Expression to only include information in report
Replies: 4
Views: 5678

Re: Expression to only include information in report

I have now tried the below. Which still doesn't remove the lines without this text but does show the text now not a number.

PROJECT_COST_CODE.REFERENCE LIKE ("ENG20")
by Barlow81
20 Jan 2022, 15:05
Forum: Sage 50 UK version General Help
Topic: Expression to only include information in report
Replies: 4
Views: 5678

Expression to only include information in report

Hi, I have designed a report and want to write an expression to only include certain cost codes. I have just used.... PROJECT_COST_CODE.REFERENCE="ELEC20"OR PROJECT_COST_CODE.REFERENCE="ELEC30"OR PROJECT_COST_CODE.REFERENCE="ELEC99"OR PROJECT_COST_CODE.REFERENCE="E...