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..

Outcomes