Multiply fields from different indices


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?