I would like to have options to enter either fields (selling price or margin) and the other should be automatically calculated for instance:

    

     Cost Price = 100 (Available)

     Sell Price  =  Calculation field or ?? Input amount

     Margin     =  Calculation field or ?? Input percentage

    

     If i put 160 on sell price it should automatically put 37.5% in margin or if i put 37.5% in margin field it should automatically fill sell price for 160.

File uploaded

Login name: admin

No Password: 

 

Thank you in advanced.

TEST.fmp12

Edited April 24, 20187 yr by Kishan_Canoo
Add file

Hi Kishan_Canoo,

We need more information about what you are trying to do because, I suspect that you have more then one product and the sales price isn't always 160. 

One of the great thing about this forum is that you can always attach a file which will speed things up in finding an answer to your question. See the Guideline for how to deal with confidentiality.

 

Filed attached to Original Post.

TEST.fmp12

Edited April 25, 20187 yr by Lee Smith
Removed quote

I looked at your file -  "TEST.fmp12"

I don't understand why you're applying a Margin based on cost. The  "TEST.fmp12" clearly shows the problem with doing that, i.e. you have 3 items with a cost $100 with 3 different Margins.

Shouldn't your margin / selling  price be  based  on the products themselves?

Lee