Query about financial year!

[#1]

Hi All,

This is the expression i used to calculate the increase in current year sales when compared to the previous year.

Sum({$<Year={$(=Max(Year))}>} SalValue) / Sum({$<Year={$(=Max(Year)-1)}>} SalValue)

But now i want to calculate the increase in current financial year sales when compared to the previous year. Let me know what changes has to done in the above expression to get the needed result.

By the way i use the following query in the list box to get the financial year. Let me know whether it can be added to the above one or not.

=yearname(Date,0,4)

Thanks and Regards,

Rikab

[#2]

Try this ;

Sum({$<Date={">=$(=date(max(yearstart (Date,0,4))))<=$(=date(max(yearend (Date,0,4))))"}>} SalValue)
/
Sum({$<Date={">=$(=date(addmonths(max(yearstart (Date,0,4)),-12))))<=$(=date(addmonths(max(yearend (Date,0,4)),-12)))"}>} SalValue)

Best Regards

[#3]

Hi Onder!

Thanks for effort but it doesn't work.

Thanks and Regards,

Rikab

[#4]

Could you please check the sample ? Its working.

Best Regards,

[#5]

Hi Onder!

I have checked it in yours it is working in yours but it is not working in mine. I guess the problem may be because of the date value. All my date values start with the starting day of the month and there is no month end date. Is that creating the problem? Please check and let me know. In your also you keep only the starting date of the month then check your set analysis.

I am also working around. Will check and let you if i get any solution.

Thanks and Regards,

Rikab