Business Objects 6.5 convert number to text

building reports desktopintelligence
1

In Business Objects 6.5 I want to use the Leftpad function to add a string of text characters to the beginning of a number. It displays error DMB0003 Incorrect Data type which i gather from reading the function definition is a result of using a number string with a text string but I can’t figure out how to convert the number field to a text. Can I get some assistance?

Thanks!

kwc3113 (BOB member since 2008-03-27)

2

Welcome to B:bob:B!

Use

FormatNumber(<object of a number type>,"0")

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

3

Thanks!! It was a newbie question, certainly, but a much appreciated and quick response. It worked and shed some light on how to use these functions.

Thanks again!!

kwc3113 (BOB member since 2008-03-27)

4

any specific reason why the zero (,“0”) is used at the end?

FormatNumber(,“0”)

tantetruus (BOB member since 2008-11-11)

5

you can try this below as well

=Char()

where is numeric type, will convert to Character String

Atik :india: (BOB member since 2011-10-03)