Expression to only include information in report
Posted: 20 Jan 2022, 15:05
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="ENG20"OR
PROJECT_COST_CODE.REFERENCE="ENG30"OR
PROJECT_COST_CODE.REFERENCE="ENG99"OR
PROJECT_COST_CODE.REFERENCE="MAN20"OR
PROJECT_COST_CODE.REFERENCE="MAN30"OR
PROJECT_COST_CODE.REFERENCE="MAN99"
but when i send report to excel the ones i don't want come up as 0.00000 and ones i do come up as 0.00001.
I want the report to still should the text as above but only the ones above no others.
Please help.
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="ENG20"OR
PROJECT_COST_CODE.REFERENCE="ENG30"OR
PROJECT_COST_CODE.REFERENCE="ENG99"OR
PROJECT_COST_CODE.REFERENCE="MAN20"OR
PROJECT_COST_CODE.REFERENCE="MAN30"OR
PROJECT_COST_CODE.REFERENCE="MAN99"
but when i send report to excel the ones i don't want come up as 0.00000 and ones i do come up as 0.00001.
I want the report to still should the text as above but only the ones above no others.
Please help.