Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Help me to create inventory system based on price

222 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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! :slightly_smiling_face:

Thanks,

1 Reply 1

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.