Hi,

Your requirement looks interesting.

But the 'amt+sign' is still returns string type and I guess derived column can not type cast it to decimal type.

I suggest instead apply /100 on amt and then concatenate the result with sign and keep it as string type only.

Regards,

Durga.