the expression or subexpression at position uses an invalid data type (IES 10037)

[former_member960559]

Hello to all.

I have an issue.

One dimension is called YQuarter and is a Number of 5 digits.

I need to extract from this dimension the last number.

I tried ToNumber(Substr([YQuarter];5;1);"0") but I got the invalid data type message.

Tried also Right([YQuarter];1) andToNumber(Right([YQuarter];1);"0") => same message

HELP !

[denis_konovalov]

You selected a completely irrelevant tag for your question and since you haven't mention the actual tool/product you're using I have select most possibly matching based on error number.
Please be more descriptive next time and select your tags more careful.

[Joe_Peters]

If the dimension is numeric, then you're on the right track but thinking about it backwards. You need to convert it to a character string first. Try:

=Right(FormatNumber([YQuarter];"0");1)