Blank Field Equals To Zero Value

[naidah14]

Hi, 

I'm new to Caspio. Using trial version for 3 days already and I'm impress with it.

 

Q: How can I configure blank field equals to '0' value?

 

Thank You 

[Jan]

Hello naidah14,

 

Maybe, conditions in Calculated fields can help.

 

Does it work for you?

[NailDyanC]

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.

[JolliBeng]

Hi,

You can also use CASE-WHEN on your formula. Here's an example:

CASE

WHEN [@field:test_field] IS NULL

THEN 0

END

 

-JolliBeng

[DefinitelyNot31337]

Hi,

 

I'm not sure about the context of your question but; it might be helpful for you to know that we can use Triggered Actions to set the default value of a field.

 

There are other options as well. You may refer to this documentation for more information.

 

I hope this helps.

-DN31337

[SinJunYoung]

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

[RuisiHansamu]

I tried the formula provided by Jolibengs: 

CASE

WHEN [@field:test_field] IS NULL

THEN 0

END

And worked on my end. I tried it on the Tabel level using formula field. I also found a helpful forum post here:

 

[DaveS]

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

"