Syntax problem i calculation

[#1]

I´m trying to do this calculation in a list caption:

I have a list that looks like this

2008 1000

2009 1500

the 1000 and 1500 is the frequency

=sum(sales=''2009) - sum (sales='2008')/sum(sales='2009')'100 & '%'

this should give me an increase percentage - but the resultgives me the number - 150268 ???????????

[#2]

Hi amars - doesnt work - gives no result

[Miguel_Angel_Baeyens]

Hello,

Use Num() function as follows:

Num(your sum expression here, '#0.0 %')

which will return only one decimal.

[#4]

Hi,

can you share the application with limited data or dummy data.

Regards

Rajesh

[#5]

Hi You all guys

You gave me inspiration to work it out and I works for me like this

=left((sum(sales=''2009) - sum (sales='2008'))/sum(sales='2009'),5)'100 & '%'

this gives me 31,7%