My wife has started an online clothing business. As of right now I would like to help her by tracking the customer data and the amount spent in a coda table.
Sometimes customers use discounts. To track this I have added a column that allows to pick a certain percentage (this is a lookup column pulling from a table with percentages).
The final column calculates the price of the product and the discounts used (if any).
It doesn’t want to use the percentages though.
As long as I just make a select list or a lookup that uses ) 010, 0.20, … there is no problem. But it looks way cleaner when using actual percentages.
Does anybody know a workaround for this?