# Replacing Empty Cells

**URL:** <https://community.amazonquick.com/t/replacing-empty-cells/10922>\
**Category:** Q&A\
**Tags:** error, calculations, quick-sight\
**Created:** [March 9, 2023, 9:26pm UTC](https://community.amazonquick.com/t/replacing-empty-cells/10922 "2023-03-09T21:26:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![taraallison82](https://avatars.discourse-cdn.com/v4/letter/t/e8c25b/32.png) [@taraallison82](https://community.amazonquick.com/u/taraallison82)\
**Post date:** [March 9, 2023, 9:26pm UTC](https://community.amazonquick.com/t/replacing-empty-cells/10922/1 "2023-03-09T21:26:35Z")

</div>

Hello,

I’ve attempted to replace empty cells with 100, 100%, or NULL and I am unable to get the syntax to work.

Some examples of what I’ve tried:

(1) ifelse({TOTAL SCORE},‘’,NULL,{TOTAL SCORE})  
(2) ifelse({TOTAL SCORE},‘’,100,{TOTAL SCORE})  
(3) ifelse({TOTAL SCORE},‘’,100%,{TOTAL SCORE})  
(4) ifelse({TOTAL SCORE}=“”,100,{TOTAL SCORE})

All of the empty cells need to be replaced with 100 or 100%.

Thanks!

![Empty Fields](https://d1wl4jav5dp96l.cloudfront.net/original/2X/2/2bdc4a1a5f3ae3a6f91bd94f77cf7aa18cf9f729.jpeg)

---

<div class="post-metadata">

**Author:** ![thomask](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/thomask/32/3124_2.png) [@thomask](https://community.amazonquick.com/u/thomask)\
**Post date:** [March 10, 2023, 6:31am UTC](https://community.amazonquick.com/t/replacing-empty-cells/10922/2 "2023-03-10T06:31:39Z")

</div>

Hi,

If they are empty, then the column has string as the datatype?

Then you could use ifelse(strlen({TOTAL SCORE})=0,“100”, {TOTAL SCORE})

If it is not a string then

ifelse(strlen(toString({TOTAL SCORE})) =0,100, {TOTAL SCORE})

---

<div class="post-metadata">

**Author:** ![taraallison82](https://avatars.discourse-cdn.com/v4/letter/t/e8c25b/32.png) [@taraallison82](https://community.amazonquick.com/u/taraallison82)\
**Post date:** [March 10, 2023, 2:13pm UTC](https://community.amazonquick.com/t/replacing-empty-cells/10922/3 "2023-03-10T14:13:12Z")

</div>

Hi Thomas,

The data type is not a string but numerical. Each column is a calculated field. I’ve found another solution that worked.

Thanks