Equivalent of to_char() in WebI as in Designer

system · December 18, 2011, 12:25pm

How can we convert an object which is of datatype number to character in WebI as we have similar function to_char() available in designer

for eg i have an object name MONTH and its value is 2 which is number .Now i want to create a variable in report which converts number 2 to ‘2’

bob2210 (BOB member since 2010-09-23)

system · December 18, 2011, 5:35pm

FormatNumber()

Nick Daniels (BOB member since 2002-08-15)

system · December 18, 2011, 6:02pm

Nick,

Can you specify the exact formula to convert 2 to ‘2’.

bob2210 (BOB member since 2010-09-23)

system · December 19, 2011, 1:45am

=FormatNumber(2,"0")

Marek Chladny (BOB member since 2003-11-27)

system · December 19, 2011, 4:54am

Thanks Marek and Nick!

bob2210 (BOB member since 2010-09-23)