You can easily undertake this example yourself:
The most important table, ventureseveral hours, is actually accurate documentation of work tickets that record the quantity of hours an individual has done a certain task.
This 2nd dining table, CompanyProject, try a listing of works with a designated priority: A, B, or C.
Notice that each table possess a venture column. Each is known as a little different, but the values seem like theyre the same. Thats vital, and really make contact with it around quickly.
Since we have the two dining tables imported into a model, let us create a study. The very first thing we should bring may be the few several hours published by task priority, therefore we identify consideration and several hours from the areas pane.
When we evaluate our very own table into the document material, youll start to see the wide range of hrs try 256 per venture, coincidentally the total. Obviously this quantity isnt correct. Exactly Why?