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.
Oct 01, 2021 06:18 AM
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,
Oct 01, 2021 09:16 AM
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.