Using LEFT/RIGHT Functions to specify records returned
I've got a column in my report database table that has up to 23 characters separated in a 2.5.5.8 configuration. Some items are 2DOT, some are 2DOT5DOT, 2DOT5DOT5DOT and some are the full code, like this:
15.
15.15400.
15.15400.15410.
15.15400.15410.15410150
I want to group on the items that have a 2DOT configuration, 02., 15., 16., etc. I tried setting up a Parameter and using this formula "LEFT([IDW_COSTDETAIL.ITEM_REFERENCE], 3)" but the report generates an error message that says, "The name 'LEFT' does not exist in the current context."
How can I do this in the report? Do I have to generate another table that splits out those specific codes instead?
Thanks,
Mike
15.
15.15400.
15.15400.15410.
15.15400.15410.15410150
I want to group on the items that have a 2DOT configuration, 02., 15., 16., etc. I tried setting up a Parameter and using this formula "LEFT([IDW_COSTDETAIL.ITEM_REFERENCE], 3)" but the report generates an error message that says, "The name 'LEFT' does not exist in the current context."
How can I do this in the report? Do I have to generate another table that splits out those specific codes instead?
Thanks,
Mike