Calculate multiple lookups

Hi @Noel_Bolger,

Im a bit lost as what exactly is your question.

You want to add a second link field where? Is it IF(AND()) or maybe IF(OR())?

I have a table, first column is a link to another table,this table has workers with different rates , each worker has a different rate per hour, this formula works, IF({Field 18}<24,{Look up}*Duration/3600) with start stop time with a single record is selected in a row, I want to select several workers with different rates in a single row, I need to call each linked workers rate separately and then apply the time formula.

Oh ok I get it.

Are all workers working the same duration or does each one have a different duration?

If all workers work the same duration, so you need to Rollup the rates into one column, then use this rolled rate in your equation.

If each worker has a separate duration, then it will become a littlee bit more complicated.

I would be able to help you more if I see your base.

BR,
Mo

In this case, they all have the same hours so rollup works, thanks for that,
Duration*{Field 44}/3600
Now I just need to select durations below 12 hours, if you know of the top would appreciate it will take me a while to work out I don’t do these often. ie if duration <12 then
Duration*{Field 44}/3600

Thanks

Hi Noel,

I dont follow, the formula you have looks just fine for what you described.

IF({Field 18}<24,Duration*{Field 44}/3600,0,) can you see what is wrong this is not working
Regards
Noel Bolgerm 0404396597
e carpentryplex@gmail.com

w Website

Here you go

IF({Field 18}<24,Duration*{Field 44}/3600,0)

There was an extra comma in the end

Thank you very much, that comma could have cost me hours, working great now.