I am thinking of how to make it easy in making a calculation by percentage or number.
Currently I have in the monday,
*column1 Price ** column2 discount % column3 Amount ( Price discount%)
Issue is when customer ask specific amount for negotiation, it is hard to find right % to make that amount… let’s say
**price 330$, ** negotiated price 290$ discount %=?
I want to use two options in my monday.
Of course, we can use calculator, Do you any good idea on how to make it in the system to use of both way above.
You can use the formula column to achieve this if you’re on the Pro plan or above. Let me know if this formula is what you’re looking for to pull that discount percentage:
Hi Bianca… thanks always for a quick and kind reply… Actually I just want to find out combination of two options which are available at the same time.
If I know exact DC %, then I just put % which will make the amoutn [Price* (1-DC%)= Amount]
Or
If I know exact Amount(final), then I just put Amount which will make % [Price-Amount/Price*100], as you wrote.
What can I put those two options in the culmun?
Regards Kevin
Ah, thank you for clarifying Kevin - apologies for my misunderstanding!
If I am correct in understanding, you’d need to create 2 seperate formula columns as I am afraid it isn’t possible to have 2 formulas targeting to 2 seperate columns at this:
One that is specific to the amount value for when you know the exact DC %
Another that specific to the DC % when you know the eexact amount value
It’s important to note that natively, it isn’t possible to populate a numbers column through a formula column. You can certainly look into third-party apps via the apps marketplace to achieve this, specifically one called general caster which is able to cast results from the formula column to a specific numbers column…
For calculating the discount percentage when you know the original price and the negotiated price, you can set up a formula directly in your Monday.com system. Here’s a quick way to do it:
Add a Formula Column: This can automatically calculate the discount percentage based on the Price and Negotiated Price.
Formula: ((Price - Negotiated Price) / Price) * 100 This will give you the discount percentage needed to reach the negotiated price from the original price.
Reverse Calculation: If you ever need to find out the final price after applying a specific discount percentage, you can use another formula:
Formula: Price * (1 - (Discount % / 100)) This will calculate the final amount after the discount.
Setting up these formulas will allow you to handle negotiations and calculations efficiently, directly within your system without manual calculations.
For further calculations or to check how two values increase or decrease by percentage, you might find our Online Percentage Calculator helpful: Online Percentage Calculator
