Skip to Content
0
Former Member
Jul 04, 2013 at 02:57 PM

substr() function on number values do not return correct values in webi 3.1

173 Views

Hi friends,

I have a 6 digit number value like 122012 which denotes month Dec and Year 2012 .I have to seperate the month as 12 and Year as 2012. I defined a variable using below formula,it gave me invalid datatype

=(Substr([SMM Realized Savings Month Code];1;4))

How can I convert the value to string before applying SUBSTR.

I didnt find tochar function in the list

Thanks

Reena