Formula displaying incorrect result

[Dhaval_Gorasia]

Hi,

As you can see in the image, formula (price - discount + shipping charges) is returning 1 in first field as I have two values separated by commas that is 399,1076.
Is there any way to write this formula, so it takes into account units separated by commas and return the correct result.

[augmented]

Hi Dhaval. Assuming you want to sum all the prices in the “Price” field before subtracting discount and adding shipping, I would use a “rollup” field, instead, that summed those prices for you.

Airtable Support

Rollup field overview

A rollup field performs calculations, create aggregates, and build formulas on specific cells from records that are linked to another field in your table. IN THIS ARTICLE Add the rollup fieldChoos...

[Dhaval_Gorasia]

Thanks,
But I want Prices after deducting Discount.
To give a better idea refer image in which I have not used any formulas and have entered figures manually. So, let’s say price of one product is 399 and discount is 50, & another product’s price is 1076 and discount is 40. So I want result of (399-50) & (1076-40) i.e 349,1036. I want exact same results when I enter formula so that I don’t have to do calculation manually for the every record I add.

[augmented]

Oh, I see. You want to end up with an array of invoice prices derived from other arrays. If the unit discount and the shipping is specific to each customer, then I really don’t know how to do this in Airtable. Hopefully, someone will but there’s not much array magic available in formulas.

[kuovonne]

Math with lookup fields does not work the way you want.

You should use a junction table where you enter the discount for each item in the sale and calculate the discounted price. Then you can rollup all the discounted prices.

[Dhaval_Gorasia]

I could do that but the real challenge is that I have listed multiple coupon codes on multiple e-commerce platforms (amazon, Noon, etc), so there is not specific discount code or rates for products. Additionally, I also sell my products on my website at full prices (no discount). So there would be a myriad types of invoices from where I’d be recording discounts. It could be 0, 50, 10, anything.

[augmented]

I assume that you could use an automation, triggered on specific field updates, to run a script that iterate/calc through the arrays.