Forum Discussion
phaum1967
Resolver I
Resolver ICalculation between two tables without simple links
Hi Everyone, I m trying to calculate revenues for each employees with two tables: First one is Invoices with ClientID, Qty, UnitPrice, totalAmount (but I've no info about people and more tha one...
v-sihou-msft
Microsoft Employee
Microsoft Employee
Is the "Qty" in invoice table same as the "Qty of hours" in second table?
As you said you can offer hours for many times for one client, how did you map different unit prices into second table? I assume you suppose to have task/event id columns in both tables?
Can you share some sample data?
phaum1967Resolver I
Resolver IHi,
Yes Qty tracked are hours in both cases but there are diffrent as in one I track all times and in the second, I invoice a part of hours (some hours are offered).
No I ve no task or event id in the two tables. My only relation possible is ClientID.
Sorry I can t share because there is confidential infos.
thanks for help....