I cannot multiply my filtered percentage


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