AnsweredAssumed Answered

Help with calculation

Question asked by Sonoran on Aug 20, 2009
Latest reply on Aug 20, 2009 by mrvodka


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.