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

Changing data format of a calculated row in a cross tab

Started by maverick_hs, 01 Mar 2006 08:46:55 AM

Previous topic - Next topic

maverick_hs

Hi,

Using the ideas discussed in some other posts here, I was able to create a calculation on my cross tab, (i.e. using tabular sets).

So, I had a row A and a row B (both dollars). I wanted a row C which is A/B. I have it now using tabular sets but the problem is that C is also displayed as dollars. Can I change the format somehow only for C without affecting A and B? I couldn't find any such feature in report studio...

Could it be done by modifying the xml somehow?

Thanks a lot for any suggestions.

CoginAustin

Change the format to what? It is just a data item. You can cast it to be whatever you wish.

maverick_hs

I should have been more explicit in my question. All three rows A,B and C are numbers but when I am displaying it on the report, I choose to display it as currency, which is what I want for A and B. But I don't want to display the $ sign for C.

I don't think using cast in the expression for C will solve this issue. If it could, then I am not able to follow.

Thanks a lot for any help.

CoginAustin

conditional variable. if row <> c then diplay $?

bdybldr

Maverick,
Any update on this issue?  Please post your solution if resolved and close this topic.  Thanks.