Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a scenario in which user selects Month-Year(Mar-2015) in MothYear field.then i have to claculate growth of sales accordingly w.r.t Last year(Mar-2014) sales.
Ex: 1-(Mar-2014(sales))/(Mar-2015(Sales))
How can I do that.
Thanks In Advance.
please provide some sample data
use set Analysis in Expression
= 1-(sum({<yourdatefield={'=$(=addmonths(yourdatefield-12))'}>}Sales)/sum(Sales))
/sum(sales) need not be enhanced by set Analysis as user selects march 2015 and therefor sum(sales) gets exactly that sum
Month-Year sales
Mar-2015 200
Mar-2014 150
If user selects Mar-2015 then i have to calculate
1-(150/200)
Are you calculating this in a chart or a text box object??? If its in a text box object, you should be able to do what Rudolf Linder suggested. If its in a chart where date is a dimension then you would need to use above function.
HTH
Best,
Sunny