Hi all, 

Not sure what I am missing with this one

I have a table cost_table and the key variablesI am trying to use with the calculation is the cost_amount and cost_type (labeled Cost and Type) and the output field line_cost

I also have a separate number field called number_of_students (this is also populated by a calculation not sure if that makes a differnece)

The formula is set so If the type is set to Per Student (option value 2) I would like it to multiply the cost amount with another field , number_of_students)  However I receive an error.

My formula is 

=IF(cost_table.cost_type=2,MULT(cost_table.cost_amount,number_of_students),3)

Have also tried

=IF(cost_table.cost_type=2,(cost_table.cost_amount * number_of_students),3)

Any ideas?

Thanks