If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Put really long numbers in a crosstab cell

Started by icepick, 16 Aug 2012 04:10:45 AM

Previous topic - Next topic

icepick

I am trying to put long numbers in crosstab cells (my end goal is to transform the numbers to little balls for display purpose using a special font). It seems to work fine with number that are up to 10 positions..

So 1111111111 works fine
But 1111111111111111111 returns a weird result.. it will display 307163591

I tried formatting the cells but that didn't help. Is there a maximum on the length a number can have in a crosstab?

tjohnson3050

I'm not sure about the length limit, but instead of using font to display images, you might find working with conditionally displayed images a lot more flexible.

blom0344

Quote from: icepick on 16 Aug 2012 04:10:45 AM
I am trying to put long numbers in crosstab cells (my end goal is to transform the numbers to little balls for display purpose using a special font). It seems to work fine with number that are up to 10 positions..

So 1111111111 works fine
But 1111111111111111111 returns a weird result.. it will display 307163591

I tried formatting the cells but that didn't help. Is there a maximum on the length a number can have in a crosstab?

Yes, there is a limit, but it should be higher than 10 positions. We recently ran into problems with very small values that caused arethmetic overflow. There is an KB article describing this in detail.  It has to do with what can be represented within a crosstab . Strange that you do not get an overflow error..