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

632 Views Last edit Jul 22, 2020 at 08:11 PM 2 rev

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 !