# Replacing Numeric Column Blank Data With 0

**URL:** <https://community.amazonquick.com/t/replacing-numeric-column-blank-data-with-0/4254>\
**Category:** Q&A\
**Tags:** calculations, quick-sight\
**Created:** [June 17, 2022, 10:14am UTC](https://community.amazonquick.com/t/replacing-numeric-column-blank-data-with-0/4254 "2022-06-17T10:14:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Biswajit\_1993](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/biswajit_1993/32/20472_2.png) [@Biswajit\_1993](https://community.amazonquick.com/u/Biswajit_1993)\
**Post date:** [June 17, 2022, 10:14am UTC](https://community.amazonquick.com/t/replacing-numeric-column-blank-data-with-0/4254/1 "2022-06-17T10:14:40Z")

</div>

**PFB the screen shots of a table column data. I want to replace the blank column into zero so how can I do this?**  
 ![Numeric Column](https://d1wl4jav5dp96l.cloudfront.net/original/2X/f/f3a1be1951ff8fd7fb3df8fd387ecbc7ad47c9fe.png)

---

<div class="post-metadata">

**Author:** ![lalprasanth](https://avatars.discourse-cdn.com/v4/letter/l/b9bd4f/32.png) [@lalprasanth](https://community.amazonquick.com/u/lalprasanth)\
**Post date:** [June 17, 2022, 4:35pm UTC](https://community.amazonquick.com/t/replacing-numeric-column-blank-data-with-0/4254/2 "2022-06-17T16:35:58Z")

</div>

Hi @Biswajit_1993

May be you should try something like this, let me know

ifelse(isNotNull({Total Time in…}), {Total Time in…}, 0)

---

<div class="post-metadata">

**Author:** ![Biswajit\_1993](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/biswajit_1993/32/20472_2.png) [@Biswajit\_1993](https://community.amazonquick.com/u/Biswajit_1993)\
**Post date:** [June 18, 2022, 4:09am UTC](https://community.amazonquick.com/t/replacing-numeric-column-blank-data-with-0/4254/3 "2022-06-18T04:09:56Z")

</div>

> [@lalprasanth](#):
>
> ifelse(isNotNull({Total Time in…}), {Total Time in…}, 0)

It showing syntax of the calculated field is incorrect.  
 ![Error Message](https://d1wl4jav5dp96l.cloudfront.net/original/2X/8/86f1f1b14bb7ca705f45a50f26a2b2073644fecf.png)

---

<div class="post-metadata">

**Author:** ![lalprasanth](https://avatars.discourse-cdn.com/v4/letter/l/b9bd4f/32.png) [@lalprasanth](https://community.amazonquick.com/u/lalprasanth)\
**Post date:** [June 18, 2022, 11:59am UTC](https://community.amazonquick.com/t/replacing-numeric-column-blank-data-with-0/4254/4 "2022-06-18T11:59:45Z")

</div>

> [@lalprasanth](#):
>
> ifelse(isNotNull({Total Time in…}), {Total Time in…}, 0)

@Biswajit_1993 you have two curly in the calculation, look at the marked place

 ![Screenshot 2022-06-18 at 5.26.51 PM](https://d1wl4jav5dp96l.cloudfront.net/original/2X/b/b49ae109b36d5221d8300a5a991da4b42e864528.jpeg)