Hi,
I have two indices; 1st index is a list of staff, location and daily costs, the 2nd index is a list of projects, start/end dates, assigned staff and working days.
I would like to calculate the project cost by multiplying the staff daily cost by project working days.
I can't seem to find anything in visualisation or a scripted field.
Any suggestions?