Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ???????????
Hi Polschou,
Pls try the below syntax;
Num(((Sum({$<YEAR={2009}>} Value)-Sum({$<YEAR={2008}>} Value)) / Sum({$<YEAR={2009}>} Value)),'#0.00%')
Regards
Rajesh
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 %
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
I tried like this
=Num(((sum(sales=''2009) - sum (sales='2008'))/sum(sales='2009'))'100),#0.00% & '%'
but it doesnt work
Try this.
=Num(((sum(sales=''2009) - sum (sales='2008'))/sum(sales='2009')),'#0.00%')
why don't you use "Number" tab for formatting?.This will solve your problem
Try
= sum(If(sales='2009',Value)) - sum (If(sales='2008', Value))/sum(If(sales='2009',Value)) * 100
I just get a - so it doesnt work either 🙂
ramchander - using number for formatting only changes the formaat in the list not in the caption