Cognos BI- percent in Cross table- Report studio

[Um_Cog]

Hello world,

In my report I have a cross table with multiple measure, I need to show a column as precent.

for that column I created a data intem called %evolution= ((valueA - valueB)/ valueA) and I use the agragation 'Calcultad' and resolution 2, valueA and valueB are both data item with Total agragation and resolution 1.
In the cross table I set the format Data of column as 'Precent ' but it does not work  :-[.

I use Report Studio of Cognos BI v10

Can you help pleease .

Thank you in advance.

[Um_Cog]

help pleeeease  :'( :'( :'(

[hespora]

Hi there,


the reason why nobody is helping you is because we simply do not have enough information. What does "it does not work" actually look like? Are you getting wrong results? No results? An error message? What is happening when you run tabular data for your query? Are you getting accurate results there, and it's just not displaying correctly in the data container?

The more info you can give us, the bigger the chance that we'll be able to spot the fault.

[Um_Cog]

Ah sorry, I thought it was clear.

the cross table gives the right values but it ignores the percent format, shows just double like 0,56 , what I want to display is 56%

thank you

[hespora]

Did you by chance click on the crosstab node member (the header) and format, rather than on the intersection?

Check the attachment - clicking on red and formatting does not work. You need to click on the blue and format.

[Um_Cog]

Thank you dear  for your reply.

Yeah I did that too, no change.

But I found the problem: when I opened the lock I found that the format was set as 'Numérique' so it ignores whatever I do (Check the attachment).
to revesolve that, I opened  the lock and set data format to 'défault', then I set percent format on the crosstab node member and it works ^^

Thank you again for your reply and have a good day