pandsmarine

So you would suggest having a completely separate table similar to the table in my first post and then reference that in calculations? Sorry if thats a really newbie thing to ask. I've come up with calculations for simpler prices where only the boat length is a variable and I was assuming something similar would be achivied: If ( Jobs::BoatWidth > 7 ; Jobs::BoatLength * 2.8 ; Jobs::BoatLength * 2.5 ) The number of tins has come about from years of experience of actually supplying the paint.

Thanks Steve, Working out price by area is always a bit of a problem for us as the hull sides of canal boats vary. Film thickness would also vary when customers paint their own boats which will effect coverage. I'm just looking for a estimate and over the years the table in my first post has served us well. In light of this would you suggest another way?

Hi guys, I’m brand new working with FM and would like your help with a calculation if I may. I want a calculation to display an estimated number of paint tins needed to paint a boat based on it’s length and width. With this information I would also like the cost of the estimated paint. I'm assuming IF can not be used as there are too many variables, can CASE? With the boats width, I've got anything over 7 classed as wide, so I've been using Jobs::BoatWidth > 7 to define narrow and wide (only two classes of widths). I'm using the table below to give our customers a rough idea at the moment but would like information to be displayed in FM specific to boats length and width for each customer after entering that data: Jobs::BoatWidth and Jobs::BoatLength. Cost of each tin is £26.32. Hope I haven't left anything out and thanks in advance.