Hi everyone…

ask permission…

why does the math column in Glide fail to count numbers above one million…

does anyone know the cause?

I attached a screenshot of it.

Can you please show what the formulas are in those two MTK columns?

It’s difficult to tell from your screenshots, but my guess would be that the empty rows are probably due to a division by zero error.

For those rows that are empty, do you get a valid result if you perform the calculation manually?

if it’s done manually I get valid results

My goal is to get the selling price of the goods…

and the formula I did is

The purchase price of the goods is multiplied by the percentage and added back to the purchase price of the goods

purchase price*percentage+purchase price

The percentage column looks like it is an if-then-else column. Can you show the configuration of that column?