display % sign in the output 1

[Jyotika123]

Hi,

I have an inserted cross tab summarized on the number field. I want to display the summary field value with a % sign at the end. I tried using the concatenate operator but that returns strings only. Thanks in advance!!

 

[fisheromacse]

right click on the crosstab, select cross-tab expert, select your summarized field, click change summary, under options there should be a checkbox for "Show as a percentage of" and you can choose row or column, and it will put the % after the #.

 

[jannoth]

In CRXI, I'd use the Crosstab Expert then highlight the group field (under "Rows") and click on Group options. Next select the Options TAB, select Use Group Formula as Group name then enter:

totext ({table.numer}) + "%"

Your sort order could now be disrupted (you've converted a number into text to display a % sign. If so, then still in the Crosstab Expert, Common TAB, select Use Formula As Group Soft Order then enter:

crAscendingOrder

That should give you what you are looking for.

 

[jannoth]

Sorry, I've just re-read your initial post and fisheromacse's reply - he was completely correct ... please ignore my response - sorry.

 

[lbass]

Just click on the "%" character in the toolbar.

-LB

 

[fisheromacse]

lbass, interesting, i had never noticed that in my toolbar before.
You probably already know this, but for the rest of us...
What the toolbar % button does is a real timesaver.
It enables the 'currency symbol' in the Object's Format Editor, sets it to 'Floating' and replaced the '$' with the '%'.

 

[Jyotika123]

Cool !! thanks lbass. that was pretty easy..