VALUELOOKUP

[jbenson]

I think VALUELOOKUP is what i am wanting to use. I am trying to pull a freight rate column from one table and put those values into another table. 

Total Freight = LOOKUPVALUE(LoadTrackingData[Driver],LoadTrackingData[TotalFreightRate],'DRIVER BONUS'[Driver]) here is the formula i am using. but i get an error. i am wanting to show the values of total freight from the load tracking table in the driver bonus table. 

[vojtechsima]

Hi, @jbenson 
If you wanna find Total Freight, you have to write it like this:

 LOOKUPVALUE(LoadTrackingData[TotalFreightRate],LoadTrackingData[Driver],'DRIVER BONUS'[Driver])

[jbenson]

i get an error that says a table of multiple values was supplied where a single value was expected

[ryan_mayu]

@jbenson 

pls check the data ,i think there is a one to many relationship.

could you pls provide the sample data?

[jbenson]

i removed any relationships i had, but i still got the same error. What i am trying to accomplish is take the payroll % from table the driver bonus and divide by the freight rate from the load tracking table, i need to do this on a per row basis so its by each driver.  i do the add column and try and divde the payroll % by the total freight rate but i get the same value for each row. I am not sure if my date columns are messing me up because one has the date by the week on the driver bonus table and the load tracking table is a date by each day? i have uploaded the snap shots of the two tables 

[ryan_mayu]

@jbenson 

could you pls provide the sample data and expected output?

[jbenson]

DATE	HOURS	BASE PAY	TOTAL PAYROLL	PAY % INCOME	DRIVER
3/26/2022	69.5	12	=ROUND(IF(B15>40,(((B15-40)*1.5)+40)*C15,C15*B15),2)	=sum total payroll/freight income	SMITH
3/19/2022	62	12	=ROUND(IF(B15>40,(((B15-40)*1.5)+40)*C15,C15*B15),2)	=sum total payroll/freight income	SMITH

DATE	FREIGHT RATE	DRIVER
3/25/2022	175	SMITH
3/24/2022	150	SMITH

So here is how it laid out the hours are totaled by the week and trucking is by the day. Our weeks go Sunday to Saturday. here is how the excel sheets are laid out 

[ryan_mayu]

@jbenson 

still not quite understand your request. 

You have two tables. First table has three columns: date, hours, base pay

second table has three columns: date freight rate, driver

you want to get the last three columns of first table?

what's the expected output?

is the total payroll below correct? 

how to get the freight income?