Changing data format of a calculated row in a cross tab

[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.