Computed Fields

computedfield ComputedField {  
  label = "Stock Count";  
  value = "#{TotalStock - IssuedStock}";  
}  

computedfield AggregateComputedField {  
  label = "Customers";  
  value = "Company ${Company} has #{Customers.count(1)} customers";  
}  

Limitations

• Aggregate queries are only supported in groups. For performance reasons they will not work in lists or cards.
• Aggregate queries will not return results from OnlineOnly entities.
• Aggregate queries will only return results from ClientCached entities if the data has already been cached in the client database.