I’m using FM 14. In my DB, I have a table called Books. One of the fields in that table is Books::DateRead. On a layout based on Books, I have a field that displays the date, month and year the book was read. I’ve created a TO of Books and on a layout based on that TO and I’ve put a two-column portal.
I’d like to display in the first column all the years from say 1990 to 2016 and in the second column, the number of books read in each of those years. How do I extract the years from Books::DateRead to display them in the portal and do I create a total of the books read in each year and display that total alongside the appropriate year in the portal? I’ve tried different things but to no avail. Any help would be greatly appreciated.