Jul 17, 2017 07:36 AM
Hello, a very simple question …
How can i do an ordinary percent-calculation as follows (column “Percentage”):
Region +++ Sales +++ Percentage (favored result)
North +++ 40000 +++ 20 %
East +++ 70000 +++ 35 %
South +++ 30000 +++ 15 %
West +++ 60000 ++ + 30 %
++ Sum 200000 ++ Sum 100 %
How is the formula for the column “Percentage”? I tried it with “Sales/SUM(Sales)” in different ways, but the result is always 1.
Shame on me, but I have no idea anymore. Thanks for advice.
Oct 31, 2017 01:06 AM
holy smokes… i was nowhere close to finding that answer. Thank you!!
I had, actually tried variation like your first samples as those are logical and mathy…
I don’t think I’d have had the patience to learn that … I tried all my excel formulaic wizardry and finally gave up and just entered the actual discount amount manually (as generally speaking it’s a 10% discount it’s fairly easy to do in my wee head).
But your formula worked brilliantly, so, much appreciation for that!
Dec 01, 2018 02:26 PM
I want to put in the Trailing Stop for an amount as in stocks and I thought you might be able to help. $15.00 with a trailing stop of 25%. In Excel I out in =The column*0.07. But I can’t figure out how to do this in Airtable. Can you help?
Dec 02, 2018 06:17 AM
For a trailing stop, from my understanding that is a binary check on whether a stock has moved a given percentage from an original point. For this you would need a comparison between two points such that IF they differ by a given percent or more, it will return a value of true. So the elements are calculating the difference and a check to see if the difference meets a threshold.
IF(ABS((Original-Current)/Original) >= .15, TRUE(), FALSE())
IF the Absolute Value of the Difference divided by the Original is Greater Than Or Equal To the Threshold, return True, otherwise return False. Here I have used 15% as the threshold.
I would include a link to an example but the forum won’t let me for some reason
Dec 02, 2018 06:36 PM
Thank you so much Thomas. I think I understand but since I am not as fluid in the terminology of a formula. I sill try and send you an attachment of one and then you can maybe give me the correct formula. That would be great :slightly_smiling_face:
I want to put a 30% stop on say each stock, and do it automatically for me every time a stock changes price. The formula would be what I Paid ($13.47) and say it goes up to $60 and starts going down when it reaches 30% more than what I paid, so I don’t lose money, I will put a 30% stop on that stock, so I know when to sell. So using $13.47 if it went up to $60, then I would see if I didn’t already at $17.51 theoretically. I think I explained it correctly. Thank you for your time, I appreciate that
Patsy Pankey
Email: digitalbarn@gmail.com
Dec 12, 2018 09:34 PM
it’s end of 2018, and this “feature” of handling percentage fields still exists
Dec 13, 2018 08:36 AM
I wouldn’t count on it ever changing. They have so many enterprise level clients now that have this suboptimal percentage field behavior baked so deep into extremely complex applications that it would cause way too much upheaval to change its behavior at this point.
Aug 05, 2020 11:49 PM
Hi, I want to know how will I be able to get the percentage of a field that has answerable by yes or no. So, I want to get the percentage of who answered yes and no on a field.
Mar 27, 2021 07:14 PM
Formula: cantidad*1 / {total}
Format: Percent (42%)
Precision: 1
Sep 26, 2023 05:16 AM
Thank's man!!