Average In A Calculated Field

[TroyPurdue]

I want to chart the average across multiple columns for ALL records in the table. I know I can create a calculated field to sum using [@field:Field1]+[@field:Field2] but I can't find a way to average them and then use that calculated field on the chart.

[Jan]

Hello tpurdue,

As far as I know, you can enter the formula like

([@field:Field1]+[@field:Field2]+[@field:Field_n])/n

in your Calculated field.

[TroyPurdue]

What if some of the fields are blank? The dividing number is not static.

[TroyPurdue]

Basically I'm wondering if there is an equivalent to AVERAGE([@field:Field1], [@field:Field2]) or a COUNT function so the formula could be ([@field:Field1]+[@field:Field2])/Count([@field:Field1], [@field:Field2]).

[Jan]

You can use the formula like:

(IsNull([@field:one],0)+IsNull([@field:two],0))/(IsNumeric([@field:one])+IsNumeric([@field:two]))

 

IsNull(field,0) returns 0 if a field is blank and this allows to calculate blank fields.

IsNumeric returns 1 if the field is not blank and 0 if the field is blank.

 

But if all fields are blank, probably, the Error in formula error will be displayed.

[Aether]

Hello @TroyPurdue,

Just wanted to inform you about the new feature in Caspio
Check this documentation in Caspio’s Help center: https://howto.caspio.com/release-notes/caspio-bridge-13-0/
This release includes a new feature of Calculated value in submission form option that allows you to use a calculated field in one of your field that is saved in your table. 
However, this feature only available in the ‘Submission DataPage’.
You can also check this documentation about calculated value: https://howto.caspio.com/datapages/datapage-components/calculated-values/ 

I hope this helps