# I need zero instead of blank data in the value field well for a measure field **URL:** \ **Category:** Q&A\ **Tags:** analysis, calculations, quick-sight\ **Created:** [March 3, 2023, 1:46pm UTC](https://community.amazonquick.com/t/i-need-zero-instead-of-blank-data-in-the-value-field-well-for-a-measure-field/10669 "2023-03-03T13:46:04Z")\ **Posts on this page:** 7\ **Page:** 1
**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:** [March 3, 2023, 1:46pm UTC](https://community.amazonquick.com/t/i-need-zero-instead-of-blank-data-in-the-value-field-well-for-a-measure-field/10669/1 "2023-03-03T13:46:04Z")
Hi Team, Is there any possibilities instead of blank data for a Measure column in the value field well we can put as **‘0’**. Please find below is my scenarios If you see in the picture Job Start Date & Job End Date both have the same but it showing blank instead of zero . ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/b/b892680505cf3bdab1f2e669c04d69b9beb05db0.png) ---
**Author:** ![Max](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/max/32/2288_2.png) [@Max](https://community.amazonquick.com/u/Max)\ **Post date:** [March 3, 2023, 6:55pm UTC](https://community.amazonquick.com/t/i-need-zero-instead-of-blank-data-in-the-value-field-well-for-a-measure-field/10669/2 "2023-03-03T18:55:46Z")
Does it show the correct value for others? Can you put an ifelse around it? ifelse({total\_time}=‘’,0,{total\_time}) ---
**Author:** ![sagmukhe](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sagmukhe/32/22033_2.png) [@sagmukhe](https://community.amazonquick.com/u/sagmukhe)\ **Post date:** [March 5, 2023, 8:19am UTC](https://community.amazonquick.com/t/i-need-zero-instead-of-blank-data-in-the-value-field-well-for-a-measure-field/10669/3 "2023-03-05T08:19:31Z")
@Biswajit_1993 - Thank you for posting your query. I hope the datatype of Job Start Date and Job End Date columns are datetime. If that’s the case then you should be suing the datediff function which should return the correct value that you are looking for. Please check this link [here](https://docs.aws.amazon.com/quicksight/latest/user/dateDiff-function.html). I have tried to replicate at my end as well and it is giving me correct value. Hope this helps! ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/1/1c8b5ef664ffcf2ee4376a89baca0a364d982e3e.png) ---
**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:** [March 5, 2023, 9:50am UTC](https://community.amazonquick.com/t/i-need-zero-instead-of-blank-data-in-the-value-field-well-for-a-measure-field/10669/4 "2023-03-05T09:50:29Z")
Hi @sagmukhe, Thanx for your solutions but in my case the **total time** column is default column available in the table so in that case what we can do for placing **zero** instead of **Null**. ---
**Author:** ![sagmukhe](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sagmukhe/32/22033_2.png) [@sagmukhe](https://community.amazonquick.com/u/sagmukhe)\ **Post date:** [March 5, 2023, 10:12am UTC](https://community.amazonquick.com/t/i-need-zero-instead-of-blank-data-in-the-value-field-well-for-a-measure-field/10669/5 "2023-03-05T10:12:22Z")
@Biswajit_1993 - Thank you for your response. By default column, you mean that it came as part of the data source column itself. Is that the right understanding? If that’s the case then what is the datatype of the column? If that’s a numeric column then you can use the coalesce function to replace the NULL value with 0. > **[Coalesce - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/coalesce-function.html)** > > Use the coalesce function for calculated fields in Amazon QuickSight. Let me know if this helps! ---
**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:** [March 5, 2023, 10:57am UTC](https://community.amazonquick.com/t/i-need-zero-instead-of-blank-data-in-the-value-field-well-for-a-measure-field/10669/6 "2023-03-05T10:57:33Z")
Yes @sagmukhe yes it is the default column for the respective data source and the datatype is numeric so I as per your I will use the Coalesce function. Let me do that and will get back to you Thanks for sharing your idea. ---
**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:** [March 6, 2023, 5:56pm UTC](https://community.amazonquick.com/t/i-need-zero-instead-of-blank-data-in-the-value-field-well-for-a-measure-field/10669/7 "2023-03-06T17:56:37Z")
HI @sagmukhe I got the result finally thanx for your help.