Skip to Content
0
Former Member
Dec 05, 2006 at 10:10 PM

Amount for previous fiscal years?

23 Views

Dear Bwers,

I have a query with a KF Amount that is based on a filter on date field ( with a variable to and from date). Now in my query i want to display columns for Amounts from previous three fiscal years (FY(-1), FY(-2), and FY(-3)) based on the date (to and from date) that the user enters in the initial run of the query.How can i do this? Any help would be appreciated.

Thanks

Raj