AnsweredAssumed Answered

Summary Fields

Question asked by madmike6537 on Nov 1, 2014
Latest reply on Nov 1, 2014 by madmike6537

Hi All,


This seems easy, but for some reason I cant wrap my head around how I need to use either summary fields, or a calculation to get the results I am looking for.


Basically I want show to a user a simple layout in FMGO13, that will show them how many jobs they have completed and how much those jobs were worth total, by month. I suppose at some point they might want to see what all the jobs were but right now I am just trying to get the basics down. Each job has a room (these are houses) and we bill by room so my tables are as follows:


So my tables are: Customer -< Room -< Line Items


How can I show this information on one layout? I am sure I am just overthinking this..