cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jenine1_1
Frequent Visitor

Using a lookup column to calculate totals

Hello,

 

I have a sharepoint list for internal invoicing.  I have

title

date

Service 1 and Service 2 etc (lookup table)  see below

Jenine1_1_0-1637810633110.png

when setting up this column I ticked the add a column to show each of these additional field

Jenine1_1_1-1637810754399.png

which is great but now i want to be able to calculated the totals of each of these new columns into a total amount column. But when i add a calculated column it doesnt show the new columns so i can use a sum formula as in

Jenine1_1_2-1637810918876.png

= Service cost 1 * time spent + service 2 * time spent2 + service 3 * time spent 3

= $90*1hr+$60*.5hr etc

 

is there are workflow that will allow me to do this, or is there another way to add the formula in sharepoint

 

thanks very much

 

1 ACCEPTED SOLUTION

Accepted Solutions
Jenine1_1
Frequent Visitor

sorry i made a mistake.

 

I have 2 lists one with the invoicing data and another that is the list for the lookout table that is attached to Service1, Service 2 and Service3 columns.

Jenine1_1_0-1637815990088.png

my apologies, i new what i was talking about

 

 

View solution in original post

1 REPLY 1
Jenine1_1
Frequent Visitor

sorry i made a mistake.

 

I have 2 lists one with the invoicing data and another that is the list for the lookout table that is attached to Service1, Service 2 and Service3 columns.

Jenine1_1_0-1637815990088.png

my apologies, i new what i was talking about

 

 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,214)