Add Margin % or Selling Price in Stock Management

[Kishan_Canoo]

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, 2018 by Kishan_Canoo
Add file

[Lee Smith]

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.

 

[Kishan_Canoo]

Filed attached to Original Post.

TEST.fmp12

Edited April 25, 2018 by Lee Smith
Removed quote

[Lee Smith]

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