# Re: Calculate multiple lookups

1172 1
cancel
Showing results for
Did you mean:
6 - Interface Innovator

The formula below works for a single linked field look up but I would like to add a second linked record and calculate the total cost.
The scenairo is Linked field =unit /start time/ stop time = cost
I am looking for linked=unit +unit +unit etc start time/ stop time = cost on one line

IF({Field 18}<24,{Look up}*Duration/3600)

8 Replies 8
13 - Mars

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())`?

6 - Interface Innovator

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.

BR,
Mo

6 - Interface Innovator

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.

6 - Interface Innovator

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

Here you go

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

There was an extra comma in the end

6 - Interface Innovator

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