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 Polschou,

Pls try the below syntax;

Num(((Sum({$<YEAR={2009}>} Value)-Sum({$<YEAR={2008}>} Value)) / Sum({$<YEAR={2009}>} Value)),'#0.00%')

Regards

Rajesh

[#3]

Hi Rajesh

sorry it doesnt work - gives no result

I worked a little further with my own and it works now like this

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

The only problem now is that the result shows the percent like thsi 31,1234567899%

I only want 1 place after the comma - like this 31,1 %

[#4]

Hi,

Can you try to add number format infront for your calculation.

Eg. Num(<<expression>>, '#0.00%') - take out the 100 & % from the expression.

Regards

Rajesh

[#5]

I tried like this

=Num(((sum(sales=''2009) - sum (sales='2008'))/sum(sales='2009'))'100),#0.00% & '%'

but it doesnt work

[#6]

Try this.

=Num(((sum(sales=''2009) - sum (sales='2008'))/sum(sales='2009')),'#0.00%')

[#7]

why don't you use "Number" tab for formatting?.This will solve your problem

[amars]

Try

= sum(If(sales='2009',Value)) - sum (If(sales='2008', Value))/sum(If(sales='2009',Value)) * 100

[#9]

I just get a - so it doesnt work either 🙂

[#10]

ramchander - using number for formatting only changes the formaat in the list not in the caption