I cannot multiply my filtered percentage

Hi,

I’m working on this Quote Generator doc where I can add a discount from a master table and then it would automatically deduct the total of the quoted fee. But weirdly, Coda doesn’t recognize the Discount as text nor number and I cannot multiply it in anyway. Can I do something without having to make it decimal?

Done! Turns out I didn’t put .First() formula so it returns multiple value.

1 Like

Hey,

I have a similar issue. But using first() doesn’t seem to resolve the problem.
My wife has started an online clothing store. And we would like to track per person what they have spent. As we are just starting out we are keeping track of this manually.

I have a table with the information of the customers and for each piece of clothing they have bought, I can select in a seperate column what kind of a discount they have used (10%,20%,…). This pulls from a lookup table.

The last column calculates the total amount spent. But it doesnt take the percentages into account as it doesn’t see this as a number. Any workaround for this or a solution?

Cheers,
Maarten