Format numbers in one crosstab independent from the kind of fact

[charon]

Hi everybody :)
Im back from my vacatino..it was a blast, sunshine and everything. And now im back and getin confronted with several cognos challenges ;)

Heres the situation..

I have one crosstab, with several facts and fact calculations as columns. sth like

                  Fact 1                 Fact 2            Ratio (F1/F2)                Fact 3   .....
Row 1
Row 2

What im trying to accomplish is to find a way, to format all values >999 and show "> 999"...as string or as ">" and the number 999.
Ive tried several ways of conditional formatting, but i will need one style for every fact dont i?
I also tried the way of creating a boolse variable and use "Currentmeasure" in my expression, but it didnt work as expected.
Ive found a way using cond. variable and muster, but its quite complicated and i have to set it for every row.
Anybody an idea maybe how to accomplish this in an easy fashion?

Thx and ...nice 2 be back :D
cheerz :P
Charon

[tjohnson3050]

A few things to try:

1.  How about using a case statement for each column, when the data item is > 999 then display the text '> 999' and for the else condition convert the number to text.

2.  Use a case statement to return 999 when the number is greater than 999 then use a variable to conditionally display and greater than image next to the number when the number is greater than 999

[RubenvdLinden]

As far as I know, the Cognos crosstab does not accept 'text' measures.

This is my way to work around the problem:
Create a boolean variable [ColumnName]Less1000 with expression [DataItem] < 1000 and a boolean variable [ColumnName]More999 with expression [DataItem] > 999.

'Unlock' the report, then select the dataitem in the crosstab and set [ColumnName]Less1000 as the Render variable.
Next, drag a conditional block to the cell of the dataitem and set [ColumnName]More999 as the Block variable.
Set the Current Block property to yes, then add a textitem '>999' to the block.
Set the Current Block property to no again and run the report.

[charon]

Thx a lot guys, nice ideas. GOnne try them on friday back in the office, il post the result/ solution.

have a nice day :)
cheerz :P