BusinessObjects Board

Please help!

building reports webintelligence legacy
#1

I’m creating a report and I’m trying to format the numbers to appear on the table rows.
e.g
165-543
123-123
534-123
123-864
etc…

I wrote this formula:

=Concatenation(FormatNumber([SKU number];"######"); " " + [SKU desc])

which makes the numbers appear like this eg:
165543
123123
534123
123864

I can’t seem to make the numbers appear with a dash or hyphen in the middle of the hashtag ###-###.

I concatenate the [SKU number] with the [SKU Desc] description.

Please help!!

tn00551 (BOB member since 2013-08-07)

#2

Please help keep BOB friendly! Review this topic for some suggestions, thanks.

Andreas :de: (BOB member since 2002-06-20)

#3

I have removed the word Urgent from your post title.

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

#4

Thanks Nick.

tn00551 (BOB member since 2013-08-07)

#5

Sorry Andreas. Wasn’t my intention to disrespect anyone. I’ll have your advise in mind next time.

tn00551 (BOB member since 2013-08-07)

#6

No harm done :wink:

Andreas :de: (BOB member since 2002-06-20)

#7

Hi,

I think you missing including “-” in your formula.

Use below formula then you can get the expected results.
=FormatNumber([SKU number];"######")+ “-” + [SKU desc]

regards,
shekar

shekarbob :india: (BOB member since 2007-07-20)