Compare cost between two fiscal years
I'm operating on a Mac OS X using FMP 11 advanced. I want to compare the final cost of a project completed in fiscal year 2010 against the final cost of the same project that was completed in fiscal year 2011 and determine the percent higher or lower.
I haven't been able to find anything similar on the forum. I'm assuming I need to set up two portals one that will list the 2010 fy's data and one for the 2011 data. But at that point I'm stuck.
Possibly, but we have no idea how you have designed your tables and any relationships involved. We'd need to know a lot more about your database design before we can suggest a way to do it.