Forum Discussion
Help with relationships
Hi. Might be useful. However. This is my companies invoice against time. We have 50 staff, and typically 3 or 4 people will owkr on any one job. My director asked me to be able to pick out monthly totals for each staff member if I can. So I the duplication of the total will not quite get me what I need.
I will certainly study the measure suggested and may use it in some cases.
I have wtached videos where they talk about this totals not carrying across tables, but they fix it with relationships. I can never make it work :(
Hey,
as there is no clue in the data how the amount from the invoice table is related to a staff member the "correct" number (from a technical point of view) is provided by the measure, this can not be solved by data modeling, just by additional information or by some kind of business rule like this
per staff member and job no calculate
Measure * DIVIDE(individual hours, sum of hours by all staff members)
Regards,
Tom
Food for thought. Many thanks