11 Replies Latest reply on Oct 3, 2014 2:50 PM by BruceRobertson

    Good heavens, I just want to to get a sum total on a layout.

    TTerz

      Title

      Good heavens, I just want to to get a sum total on a layout.

      Post

      I've spent 4 hours on this one tiny problem if that tells you anything about how I am feeling about this issue.

      I made a report layout so I can simply total up my invoices based on dates that I select via buttons. I want to be able to view how much revenue was generated sorted by each year, and it would be nice to see how much was generated per month.

      I made a button that 'finds' a whole year's revenue based on a script but I can't for the life of me figure out how to sum all of those numbers. That's all I'm looking to do. I tried making a summary field on the table with my invoices and that works but I can't sort it. What is literally the easiest way to sum up numbers that have been sorted based on found fields in a report?

      Right now, the summary field if I put it in my report footer shows up as a '?'. It will calculate the found results on the invoice table but not here? WTF!?

      Screen-Shot-2014-10-03-at-2.10.04-PM.jpg