User Documentation
atfinity
Search…
Introduction
Guides
Getting Started
How To Guides
Troubleshooting
Advanced Topics
Glossary
Case
Instance
Process
Rules
Ontology
Information
Information Types
Information Category
Taxonomy
Document
Document Box
Document Section
Document Template
Tab
Proof
Role
Workflow
Translations
Email Templates
Maintenance Windows
Rule Language (RuLA)
What is RuLa?
Declarations
Expressions
Operators
Boolean Operators
Date Operators
Known Operators
unknown
known
SNEAKY
AVG_OF_ANY
LIST_OF_ANY
MAX_OF_ANY
MIN_OF_ANY
SUM_OF_ANY
CONCAT_OF_ANY
UNION_OF_ANY
JOIN_OF_ANY
List Operators
Mathematical Operators
String Operators
Special Operators
Conditional Expressions
Comments
Information about the case
Accessing the outcome instance
RuLa Functions
API
Generate API Keys
API Documentation
Calling your APIs within Cases
External Data Sources (e.g. CRM)
Deploying
Deploying on-site
Management commands
LDAP User Backend
Single Sign On
Integrations
Avaloq
Worldcheck
Releases
Release Schedule
Release Notes
Powered By
GitBook
AVG_OF_ANY
Description
AVG_OF_ANY
is the flexible counterpart of
AVG
.
It gives you the average of the values you provide in between a set of brackets, each separated by a comma.
If a value is not available:
AVG_OF_ANY
simply ignores it and gives you the average of values that are available
AVG
, before returning a result, will alert you to go back and provide the missing value.
​
Example
p is Person
AVG_OF_ANY(
p.income_from_employment,
p.income_from_wealth_gain,
p.other_income
)
This
expression
will give you the average number from the three types of personal income mentioned.
If the person in this case does not have any income from wealth gain, the outcome will be the average of the other two sources of income.
Previous
SNEAKY
Next
LIST_OF_ANY
Last modified
2mo ago
Copy link
Outline
Description
Example