Comparing years and months

[#1]

Hey I am trying to compare sales by years and months meaning

February 2014 sales vs February 2013 sales how can I preform this?

And how can I show it on percentages?

I am adding a picture of my app

[reddy-s · Accepted solution]

No probelm,

So that would be :

1) sum(iv_cost) - assuming year 2014 is selected

2) sum({$< year = {'$(=num((GetFieldSelections(year) - 1), '###0' ))'}>} iv_cost)

[#3]

TNX alot you realiy helping me!!

[#4]

for some reason its still not working....

[reddy-s]

Hi Jhonatan,

The fields are case sensitive.

Can you attach the QVF if possible?

Thanks,

Sangram

[#6]

TRIED IT AGAIN AND IT WORKED!!! tnx alot!!!