Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to add current year 12 month with previous year max month(means 12 th month).
for ex:
i selected financial year 2015(Apr-Mar)
i want to add ---Mar-2014+currnt year all months(from Apr to Mar)
How to pick the previous year value when i selected current year.
Urgent plz help on this.
Thanks,
Ashok.
I think you can keep the value in a variable like below. and then use the variable in the expression with the rest of the current year values.
sum({<Year={"$(=Max(Year)-1)"},Months={Mar} >} Price)
// I hard coded the month value as Mar was the highest as per your business logic
If you are having a year field, you could try like:
=Sum({<Year+={"$(Max(Year)-1)"}>} Sales)
I think you can keep the value in a variable like below. and then use the variable in the expression with the rest of the current year values.
sum({<Year={"$(=Max(Year)-1)"},Months={Mar} >} Price)
// I hard coded the month value as Mar was the highest as per your business logic