43
Views
18
Comments
Aggregate a Column into a Single Value

Hi,

I am trying to calculate values based on my attributes.

I accessed this link to help me https://success.outsystems.com/Documentation/10/Developing_an_Application/Use_Data/Query_Data/Aggregate_a_Column_into_a_Single_Value

https://www.outsystems.com/training/lesson/1975/demo-how-to-create-aggregation-functions-in-aggregates


But the menus presented do not correspond


What's going on?


i pretend to:


and


can I do the calculations directly on the screen? or do I have to do it in the database?


And how do I do the calculations?

Thanks


Rank: #128

Hi,

Can you check the datatype you used for these IVA attributes. It looks like they might be defined as alphanumeric, which you can´ t sum.

Rank: #295

Hi SpiritFox,

As the Dorine said, please check data type for your required attributes, you cannot sum or average the attribute which includes text strings.


Rank: #448

Hi SpiritFox,

The SQL Server SUM() function is an aggregate function that calculates the sum of all or distinct numeric values of a column into a table. However, it looks like the values you are trying to sum is alpha numeric where it will not work.

Thanks & Regards,

Sachin

Rank: #3244

Hi all,


The datatyoe is currency. i double check!

Rank: #3244

Hi,


How did you insert these attributes?


I've seen a video about it but I can't find it ...

Rank: #262

Hi SpiritFox,

Please check the attached example on how to get row and coulmn sum values. 

SumCalculation.oml

Rank: #3244

Hi,

I don't understand what this means:

  "€", 2, ".", ",")

In the expression:

FormatCurrency (GetTrocas2.List.Current.IVA_6Sum, "€", 2, ".", ",")

where can i find information about this?


Thanks