Are there inbuilt functions available for aggregate (Sum, Avg, Min, Max etc…). If yes please let me know the syntax for the same.
Please refer to this documentation for detailed information about commonly used functions. In addition, in the IDE click on the main toolbar Help>Help Contents:
and after that in the search field write “expressions”: