.png%3Falt%3Dmedia%26token%3D8174d25a-bbf3-43b6-9e21-3b022d5cd5ec)
.png%3Falt%3Dmedia%26token%3D8174d25a-bbf3-43b6-9e21-3b022d5cd5ec)
AVG
AVG takes all the values you provide in between a set of brackets, each separated by a comma, and gives you their average.AVG can also return the average of values that are produced by another function.
p is Person
AVG(p.base_fee, p.transaction_fee, p.report_fee)
This expression calculates the average of the base fee, the transaction fee, and the report fee regarding a person in a case.
AVG(
get_properties_from_instances(
instances(AccountHolder), personal_income
)
)
This expression works in a couple of steps to bring you the result:
AVG( .... )is the overarching function, of which you want the result. In between its brackets sits another function.get_properties_from_instances(.......)is the function inside theAVGbrackets, which goes and fetches the property of the instances you specify.instances(AccountHolder, personal_income)returns the personal income of all the accountholders.- These three combined, give you the average of the personal incomes for all the account holders in the case.
Last modified 1yr ago