Sum acrros fields

[Kennylj24]

I am attempting to sum across all fields.  This bay me simple but I am a little stump.  The use basically enters two types of data into a form. Some being a number and others a check box. What I did was apply a formula for the check box entry that stated if  Yes than equal 1. That way I am able to total those columns and convert to a number. I thought I would then be able to add that to my numbers field. I.e . New claim + Cp/CR activity+Calendars+Mail+Estimates+phone message to equal the total Task Column. For some reason no matter what configuration I use I always get a blank.  Can you please help? Is this even doable?

[eetimm]

Check your fields for null values...Caspio cannot add values if any of them are null.  Try using the form:

IsNull([@field:field1],0)+ IsNull([@field:field2],0) + .... + IsNull([@field:fieldx],0)
 

This has worked for me.

 

ET

[Kennylj24]

On ‎2‎/‎6‎/‎2017 at 11:03 AM, eetimm said:

Check your fields for null values...Caspio cannot add values if any of them are null.  Try using the form:

IsNull([@field:field1],0)+ IsNull([@field:field2],0) + .... + IsNull([@field:fieldx],0)
 

This has worked for me.

 

ET

Thank you. It works perfect.

[ParkLoey]

Hi! Just wanted to drop Caspio's function reference article here as well for everyone's reference when creating calculations:

https://howto.caspio.com/function-reference/

[Queso]

Hi, 

If you want to learn more about the IsNull function, please see the following forum post:

 

[cheonsa]

Hi all,

Just to share this with you, if you are going to use the Yes/No Datatype field in a calculation, it is better if you CAST the field as Bit, so the value would be 1 or 0.

For example:

CAST([field:Yes/No] as BIT)