Percentage in Column

[upaliwije]

I have following pivot table where I want to calculate the percentage as given below  in the last column

but when I write the following expression desired result is not shown in the % marked in red

My expression is COUNT(NOS)/COUNT(TOTAL NOS)

Pls help me rectify my expression

	PAID_YEAR	2011	2011	2011
AGENT_GROUP	AGENT_PAYEE	PAID_AMOUNT	NOS	%	Expected %
AGENT	AMW	13,908,266	332	0.41%	2%
AGENT	CARMART_LANKA	4,525,290	27	0.03%	0%
AGENT	COLONIAL MOTORS	191,827	2	0.00%	0%
AGENT	ABANS	294,065	7	0.01%	0%
AGENT	DAVID PEIRIS	575,574	12	0.01%	0%
AGENT	Total	19,495,022	380	0.47%	2%
OTHERS	OTHERS	656,896,142	19962	24.58%	98%
OTHERS	Total	656,896,142	19962	24.58%	98%
Total		676,391,164	20297	25.00%	100%

[#2]

You the Relative Property in the expression(this calculates the Percentage).

Also, Can you also look into 'Show in Percent(%)' option in the Number Format Settings in the Number Tab of the Properties

-Ram

[JonnyPoole]

replace: COUNT(NOS)/COUNT(TOTAL NOS)

with:  Sum(NOS) / Sum( Total NOS)

[upaliwije]

NOS IS NOT A NUMERIC  VALUE BUT A STRING

[upaliwije]

WHAT YOU SAY IS NOT CLEAR TO ME

[Anonymous]

then try the num#() function...something like -

sum(num#(NOS))/sum(total num#(NOS))

[upaliwije]

IT IS NOT WORKING

MY NOS IS LIKE THIS        KH1A34222

[pgalvezt]

Hi,

Try with Only or MaxString Functions ()

[Anonymous]

they are not like that in your post. can you provide correct formats for your fields? if the formats you provide are not correct, solutions will not work either.

[upaliwije]

I cant understand it . Pls write the full expression