AnsweredAssumed Answered

If function problem

Question asked by EwanMacGregor on Feb 5, 2015
Latest reply on Feb 5, 2015 by EwanMacGregor


If function problem


I've put together a table of products that we sell into the reseller market. Currently there are two manufacturers products listed.

I want to give our resellers different discounts depending on which product.

In the table I have a trade price field. I want to say If the product comes from manufacturer x then the discount is say 30%. If the product is from manufacturer y then the discount is 40%.

I have tried to put an initial calculation in the Trade Price field for one of the manufacturers

If ( manufacturer ; Yellow;30;0)  however this doesn't work. I get an error message saying. I think for the second manufacturer I need a nested If.

I would appreciate some help here.