• 0

# Average In A Calculated Field

## Question

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.

## Recommended Posts

• 0

Hello tpurdue,

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

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

##### Share on other sites

• 0

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

##### Share on other sites

• 0

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]).

##### Share on other sites

• 0

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.

##### Share on other sites

• 0

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

## 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.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.