Formula somma ricambi di una installazione

Hi Mauro -

If the reference field is called 'Ricambi installazini zanzare' then you can just drop the select. So it would look something like:

sum('Ricambi installazioni zanzare'.Totale)

Otherwise change the name to match the reference field name. This would only work in the two tables that are linked from your picture. Since the records are linked you can use the power of Ninox to do the filtering for you.

When you use a select statement you are telling Ninox to start a fresh search of the table. Which means the code your wrote is telling Ninox to grab all records in the 'Ricambi installazini zanzare' table. You have to tell Ninox how you want to filter the gathering of records. For example you would have to modify your select statement to something like:

let x := this;<--this gathers the data from the current record you are on

sum((select 'Ricambi installazioni zanzare')[field1 = x.field1].Totale)

The first way is the most desirable way to gather data as select statements are slow and too many will slow down your table.

Good luck and let us know how it goes.