Forumla Help on Multiselect field

Topic Labels: Formulas
353 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I am struggling to find the formula that I need.

I am trying to calculate the total guide cost for a trip.  I have a multiselect field for the guides that will be on the trip, then in the guide table, I have their rate per hour of guiding.  So on the main table, I have a lookup field that displays the rates for each guide.  I need to now multiply each rate by the 8 hours and then by the total number of days they are out,  and add them together.  





1 Reply 1

Change lookup field to rollup, SUM(values). Multiply it by 8 and total number of days.