Help me to create inventory system based on price

Hello…I am new.

I need some help to do something…

1/I have a column B, with a currency field.
2/I have a column C, with % field.
3/I havr a column D, of number.
4/I have a column E, of % field.
5/I have a columm F, of currency.

I need percentage of column C and E automatically.

So if :

Column B has a total of $100.

IF I insert 10% into Column C.

The column D should show me 90$.

but IF i need to changes into Column D from 90 to 95$.

then the column C shows me 5%.

reflect both sides if i changed any value from column C and D.

after that… Successive Discounts applied on column E.

I insert 2% into colum E.

Then column F will show me 88.2 (2% of 90 column D price)

and the final price show me on column F.

I.E.
B=100$
C=10%
D=90$
E=2%
F=88.2$

if changes into D it reflects to C, if changes into Fit reflects to E.

I don’t know how to create a formula which will calculate the discounted amount based on the price.

I would be great to have some help on that! :slight_smile:

Thanks,

In your case your formulas should look exactly how it would in algebra

{B} - ({B} * {C})

You cannot manually change the value of a Formula field. If you need {D} to show as $95, then you need to change the value of {C} to 5%, not the other way around. The workaround would be to include “override” fields but that would quickly clutter your table and would likely become confusing.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.