Add Calculated Field Contract on Linux

[Music] in this session I'm going to demonstrate how to use the query design and also define calculated fields or have calculated fields as part of the query design let's assume that we have a bunch of customers they have not paid their invoices and we want to calculate a late fee so part of our query we want to display what the late fee calculation would be so here's how we do that we go here under the query design and then first thing we need to pick the tables if we want to utilize so let's say we want customers then we want contracts and then let's say we wanted the invoices so I'm just going to list those three tables that we are utilizing at this point but in reality I'm going to use only customers and invoices in this case so we want the first name I'm double clicking on them last name and then let's say you either state address city state and zip and then we want also the invoice number the date the item amount and then we want what it was paid or not I'm going to resize this I'm just dragging...