help Salary contribution calculation in costing dashboard

[kakani87]

Hi Folks ....

My requirement is to display the salary contribution product/item_family wise of a employee in a month based on the spent time for that product in a day

finally that contribution need to be summarized and divide the salary product wise

below is the screen with required contribution to display

lets say an employee salaried 20000 monthly and based on the product wise contribution daily and that is to be shown month

Same details in an excel  attachment

but here for one employee I'm displaying to understand

Here I'm posting a sample data with 3 employees

Hope some one can help me out of this

tresesco‌

stalwar1‌

tamilarasu‌

[kakani87]

Month	Emp	Item/Product	Spenttime	contribution	salary
Apr-18	Emp1	P1	80 hrs	40	8000
Apr-18	Emp1	P2	120 hrs	60	12000

Required output

For example-

If an employee contributed for two products P1 and P2 as 40:60 ratio and salary is 20000  for a month

P1 = 8000

P2 = 12000

like that to be displayed

[avkeep01]

Hi Kakani,

so on the first table you have the time spend and an employee number basically. On the second table you have the salary and the employee number.

What you could do, and i'll create a basic example, is joining the tables as a first step:

Table1:

LOAD

EmployeeNr,

TimeSpend

FROM Table1;

LEFT JOIN (Table1) LOAD

EmployeeNr,

Salary

FROM Table2;

Table3:

NOCONCATENATE LOAD

EmployeeNr,

TimeSpend,

Salary/TimeSpend AS Salary_per_TimeSpen

RESIDENT Table1;

DROP TABLE Table1;

[kakani87]

Hi Van Keep,

Thanks alot for your response

here when i do left join salary is not displayed

In the table having time spent is on a product worked as well available

[kakani87]

Hello  kindly someone can look into my issue

[kakani87]

This issue of item display is due to date format and corrected

But the contribution calculation not yet

[yashdeep · Accepted solution]

Is this what you are looking for

[kakani87]

Thanks a lot Yashdeep for your support

This is what I'm looking  for