# Failed to count amount **URL:** \ **Category:** Ask for Help\ **Created:** [October 17, 2021, 1:06am UTC](https://community.glideapps.com/t/failed-to-count-amount/33159 "2021-10-17T01:06:22Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\ **Post date:** [October 17, 2021, 1:06am UTC](https://community.glideapps.com/t/failed-to-count-amount/33159/1 "2021-10-17T01:06:22Z")
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. ![Screenshot (244)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/b/db9753fcaa2e449670b3028e7374a3edc17848a2.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 17, 2021, 1:54am UTC](https://community.glideapps.com/t/failed-to-count-amount/33159/2 "2021-10-17T01:54:36Z")
Can you please show what the formulas are in those two MTK columns? ---
**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\ **Post date:** [October 17, 2021, 1:59am UTC](https://community.glideapps.com/t/failed-to-count-amount/33159/3 "2021-10-17T01:59:15Z")
Hi @Darren_Murphy here’s the formula… ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/e/6e589c4f929a56f4d9112942908f023dcdb3903b.png) ---
**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\ **Post date:** [October 17, 2021, 2:00am UTC](https://community.glideapps.com/t/failed-to-count-amount/33159/4 "2021-10-17T02:00:54Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/5/157b055d9bf8fab85a484501052c4e29da6485b0.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 17, 2021, 2:01am UTC](https://community.glideapps.com/t/failed-to-count-amount/33159/5 "2021-10-17T02:01:45Z")
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? ---
**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\ **Post date:** [October 17, 2021, 2:10am UTC](https://community.glideapps.com/t/failed-to-count-amount/33159/6 "2021-10-17T02:10:25Z")
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 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 17, 2021, 2:32am UTC](https://community.glideapps.com/t/failed-to-count-amount/33159/7 "2021-10-17T02:32:04Z")
The percentage column looks like it is an if-then-else column. Can you show the configuration of that column?