I got this error 'Unknown function Sum' when I want to sum up all the values in existing column Credit and put to a new column CreditSum.
You need to right click on the column and you get option to get sum
When I right click, I see this
you need to right click on the aggregate column. I think you are trying on entity not on aggregate.
Create a aggregate first and than try right click on the column
It also depend on the datatype of the column if it is valid for the sum (like integer) then only you are able to see the option.
Hi,
What you try to achieve is documented by OutSystems here: Aggregate a Column into a Single Value - OutSystems 11 Documentation
Regards,
Daniel
Hi Han Philbert,
Please refer the below link,
https://www.outsystems.com/forums/discussion/66940/how-to-calculate-the-total-sum-of-a-column/
Or
To create a new column in OutSystems that counts the total value of an existing column, selecting the "Count" aggregate function on the relevant column.
Right-click on the column and choose Aggregate > Count.
Also, please check the data type you are using for the count attribute.
Thanks,
Sahana