Help with calculation
I just installed a 30 day trial of FM Pro. I have an excel spreadsheet showing the books I have read over the years with the following fields DATE TITLE PAGES. In the spreadsheet I have page totals for year. When bringing it into FM the calcs didn't work (obviously). I tried creating a claculation field & got way mssed up.
I did make sure that the DATE field is in date format 12/1/2009.
How do I total my page count for each year. It seems like I have to have an if, then and a Sum(). How would that look in FM.
Thanks to all.