Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to figure out how to make a calcultaed field in the load script.
If(ActHourRate <> 0, TicTacHours * ActHourRate, TicTacHours * ListHourRate)
All fields except ListHourRate comes from TicTacTime.
Can someone please point me in the right direction?
thanks
g
If you want to do a calculation in the script then all fields necessary for the calculation need to exist in one table. That means you'll have to join tables together first. Or perhaps you can use a double applymap to get the listhourrate in the tictactime table.
thanks,
I was hoping to avoid joining them. will try to just move the one field.