How do i get total of a field in local database since agregate does not work in local.  Ex. I want to get totals sales in one local table. 


Hi,

On local entities in mobile you can do aggregates with group by and sum on the attributes you want.

Regards,

Daniel

Hi Ariel,

Daniel is right, you can use Aggregate in Local. 

Outsystems Doc:

To aggregate a column into a single value, hover on the column, click Aggregate Menu and choose one of the available aggregate functions:

  • Sum: sums all the values in the column
  • Average: calculates the average of the values in the column
  • Max: finds the maximum value in the column
  • Min: finds the minimum value in the column
  • Count: counts how many rows there are in the column

https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Query_Data/Aggregate_a_Column_into_a_Single_Value


Hope it helps,

Assif