# I need help with a calculated field

**URL:** <https://community.amazonquick.com/t/i-need-help-with-a-calculated-field/19121>\
**Category:** Q&A\
**Tags:** dashboard, calculations, Business-Intelligence-Engineer, quick-sight\
**Created:** [October 5, 2023, 12:08pm UTC](https://community.amazonquick.com/t/i-need-help-with-a-calculated-field/19121 "2023-10-05T12:08:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andile](https://avatars.discourse-cdn.com/v4/letter/a/eb9ed0/32.png) [@Andile](https://community.amazonquick.com/u/Andile)\
**Post date:** [October 5, 2023, 12:08pm UTC](https://community.amazonquick.com/t/i-need-help-with-a-calculated-field/19121/1 "2023-10-05T12:08:19Z")

</div>

Hi community,

I need assistance with creating a calculated field. I have a dataset with a field called “Transactions” which has blank values, I want to create a calculated field that converts the blanks/nulls into 0(zero). How do I go about doing that

---

<div class="post-metadata">

**Author:** ![n\_vetri](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/n_vetri/32/2924_2.png) [@n\_vetri](https://community.amazonquick.com/u/n_vetri)\
**Post date:** [October 5, 2023, 10:02pm UTC](https://community.amazonquick.com/t/i-need-help-with-a-calculated-field/19121/2 "2023-10-05T22:02:53Z")

</div>

Hi @Andile

you can try

```auto
ifelse(isNull(Transactions) ,0 , Transactions)

```

Regards  
Vetri