Skip to main content

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! 🙂


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.

Reply


Terms & Conditions