The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.
I’ve been checking around the community for a workaround for this issue.
Sooo… here’s my dilemma… I have four columns:
An item could be like a box of pens, while the pens would be the unit.
I’m trying to find the percentage of actual Units in Stock as compared to the Total Units by a percentage. I checked to make sure all columns are integers.
I tried it two ways:
-
{Total Units in Stock}/{Total Units}
-
{Total Units in Stock}/({Units/Item}*{Items in Stock})
Total Units = {Units/Item}*{Items in Stock}
PS. I tried to change all columns to decimals as well with no luck
