How to Format the huge number

building reports webintelligence
1

Hi,

Values displaying in my report are lengthy, so i want to reduce its length for simplicity. My reports are having big digits like 7000000000 now i want it display like 700M (M = million).

I am trying to find it on report graph area Right Click -->Edit Format --> Y axis --> Values --> Number Format.

But there is no such format i found in BO like in Cognos.

Can you help me how to find this in BO XI 3.1

Thanks in advance

Regards,
Siva

sivuj18 (BOB member since 2009-07-11)

2

What about dividing the object by 1000000 and then displaying the result?

Jansi :india: (BOB member since 2008-05-12)

3

I don’t want to change any SQL or update the database, want to format it on report.

sivuj18 (BOB member since 2009-07-11)

4

Creating a report level variable would do. It won’t change SQL or re-execute things at db.

Jansi :india: (BOB member since 2008-05-12)

5

Yeah it works thank you so much…But my intention is on finding format option like in cognos.

Any way thanks alot for your support…

sivuj18 (BOB member since 2009-07-11)

6

Hi,

Jansi’s suggestion may also be applied to the Universe level for an new object, giving you the format you want instantly as well.

Joe Szabo :us: (BOB member since 2002-08-19)

7

I think in current days Cognos cannot match BO’s level of reporting.

Anyways thats not the point of discussion. To get the desired result you can create a variable.

var = [number]/1000000 concatenation_operator “M”

or you can use the scientific value #.###E# where # can be any number.
for example: 120000 =1.2E5

Also As far as i rem’ber this functionality is enhanced in XI 3.0 and above… 'coz Voyager which is a part of XI 3.0 and above displays data in Thousands as K, Millions as M and so on…

I hope this will help you in some or the other way.

Cheers,

shiva.tomar (BOB member since 2007-10-05)