Jump to content
  • 0

Average In A Calculated Field


TroyPurdue
 Share

Question

5 answers to this question

Recommended Posts

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

Link to comment
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 :) 

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

×
×
  • Create New...