numer

[smilingjohn]

hi in a text box i ave taken a expression and the output is like

7623,28%

it should be like  after 2 digits .

how do i write it ,,,iam including ##.#%

[sergio0592]

Try with :

Num(Your field,'# ##0.00%')

[smilingjohn]

Hi Jean Thanks

And also i wanted to know Iam using a oie chart  with cyclic drilldown , i want to sort  the expression how do i do it ...becuase under sort the expression is disabled

[Anonymous]

Hi

Right Click Chart Properties>Dimensions>Edit Groups>Your Groups>Edit>Sort Orders>Ok>Ok>Ok

Hope it helps!!

[smilingjohn]

Hi Anil ,

I did it as per your suggestions ...But i see the pie chart displays the legends as per the amuont of percentage ..greater the percentage first is the legend being displayed .

I have sorted like

Blocker,Critical,High,Medium,Low Unassigned

and n the chart i see it like this as shown in the image

[smilingjohn]

yes, but how can achieve my sorting order as per the epression i have writen ?

[sergio0592]

So your sort is per amount percentage. Unassigned is the bigest part, medium the second,...

You want sort Blocker in first, Critical in second,High in third, ....  Is it that you're trying to achieve?

[smilingjohn]

yes i want the legends to be displayed like

Blocled

Crictical

High

Medim

Low

and thats the reason i wrote the expression like

match(Blocker,Critical,High,Medium,Low Unassigned)

[sergio0592]

I think it's because you miss simple quotes, try:

=match(Priority, 'Blocker','Critical','High','Medium','Low','Unassigned')

[tajmohamed30]

you can try to display numbers/percentage in legends as inside chart numbers are collapsed or you can try to arrange it by ctrl+alt