Unanswered

Getting Total Value from a column and used in another list

(0) Share

Report

Posted on by Rirag

Hello Community,

I'm currently facing an issue with SharePoint lists and could use some assistance. In my SharePoint site, I have two lists related to cost management: "Cost Company" and "Employee Cost."

In the "Cost Company" list, I have a calculated column called 'totalcost' that calculates the total cost for each item row, taking into account the value and frequency of the expense. For instance, the administrative total cost is calculated as Value * Frequency and building total cost the same, because is a calculated column I cannot persent a total for this column which I can still pass however I need this total for the another list.

Now, in the "Employee Cost" list, I want to create a column called "Distribution" that will display the same value for each employee and is an equal distribution of the company total cost. To achieve this, I'd like the "Distribution" column to calculate the sum of the "total cost" column from the "Cost Company" list and then divide it by 220 days (the total number of working days in a year).

I'm wondering if anyone has any ideas on how to achieve this using Power Automate or any other method?

Thank you in advance for your help! Any guidance or suggestions would be greatly appreciated.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Rhiassuring 8,692 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hmm. Is there a different set of companies, or a different set of costs? (Like it looks like you said "Administrative"). (I'm trying to identify what we might need to filter by to determine all the specific employees that are associated.)

How is the Employee connected to the Company Cost? Is their Company or Role or something similar captured somewhere? Maybe if you showed an (anonymized) version of the two lists you have, that could be helpful.

But, yes you can do this with Power Automate, for sure.

Was this reply helpful? Yes No
Rirag 35 on at

Like (0)

Report
Copy link

Link copied!

Hi !
Thank you for your reply. Here a more precise description of the problem and as advised by you I added some pictures with dummy data of what I will like to achieve.

In pics 1 we have the first list called Teals cost which have a list of cost and its value per year and in the last column I compute this value per day, simply by dividing the value for 220 working days.

In pics 2 we have the second list called Employee Cost here we have the cost per employees per year and also the days cost. I will like compute the contribution of the Teals cost per employee, for that I need the sum of the last column in the first list divided by the number of employee,( 2 in this example) and this valued is the one to be inserted in the column Contribution. If I make the computation manually in the column Distribution of both employees I should have 247,28 as value for the two employees.

I have made some flow in Power automate but it doesn't work 😞

Kind regards,

Was this reply helpful? Yes No