We have FYs between July and June. As most of my reports are based on one or two financial years (for example FY 17 or 18), I end up hard coding my reports using these two years. But at he end of a FY, this would be a laborious job for me to review all reports and edit these to add one more year.
Wondering if there was a possibility that I could use a formula that always works out the current and next FY to achieve this and add that field to all reports. I am currently using a calculated FY that calculates FY based on a date. Issue is how to restrict this formula field to only cover two FYs unless there is an alternative approach? Will appreciate some help.
Wondering if there was a possibility that I could use a formula that always works out the current and next FY to achieve this and add that field to all reports. I am currently using a calculated FY that calculates FY based on a date. Issue is how to restrict this formula field to only cover two FYs unless there is an alternative approach? Will appreciate some help.
-
3,152 Points
Posted 2 years ago
QuickBaseCoach App Dev./Training, Champion
-
65,280 Points
