AnsweredAssumed Answered

Help with calculation

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

Title

Help with calculation

Post

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. 

Outcomes