Ruly makes it easy to add calculated fields directly to a View without creating additional fields in your database.
SQL Formula fields can handle simple calculations, such as calculating a claim total including tax, as well as more advanced calculations using SQL Window functions.
Use functions like `PARTITION BY` to calculate values across groups of records and `ORDER BY` to create cumulative running averages, giving you more flexibility when displaying calculated data directly within your Views.
See how this is done by watching the short video clip below.