Jump to content
  • 0

Blank Field Equals To Zero Value


naidah14

Question

7 answers to this question

Recommended Posts

  • 0

Hi,

Just to add to the previous comment above, if you want to submit values even if the field is blank you can use ISNULL for that let say for example:

ISNULL([@field:Original_Art_Time],0) + ISNULL([@field:QE1_Time],0) + ISNULL([@field:QE2_Time],0) + ISNULL([@field:QE3_Time],0) + ISNULL([@field:QE4_Time],0) + ISNULL([@field:QE5_Time],0)

I hope that helps.

Link to comment
Share on other sites

  • 0
On 2/1/2019 at 10:41 PM, NailDyanC said:

Hi,

Just to add to the previous comment above, if you want to submit values even if the field is blank you can use ISNULL for that let say for example:

ISNULL([@field:Original_Art_Time],0) + ISNULL([@field:QE1_Time],0) + ISNULL([@field:QE2_Time],0) + ISNULL([@field:QE3_Time],0) + ISNULL([@field:QE4_Time],0) + ISNULL([@field:QE5_Time],0)

I hope that helps.

Also if you have Sum(IsNull(field,0)) and you wanted to place 0 value for your  every blank, you can always revert this to fill in actual 0 value in your table. 

You should try something as this: IsNull(Sum(field),0)

Hope this helps

Link to comment
Share on other sites

  • 0

This might seem ridiculous, but I wasn't sure if it would work the opposite way (ELSE NULL).  I.e., I have a field that I want to set to Null instead of zero in a given situation.  Worked just fine, happily

CASE WHEN X=Y

THEN Z

ELSE NULL

"

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...