tAggregateRow - sum double variables possible?

[Anonymous]

Hello, quick question to which I couldn't find the answer elsewhere.
Will tAggregateRow's sum function work if I feed it with double values or does it only work with ints?
Thanks in advance

[Anonymous]

Hi,
The tAggregateRow support for double data type.
To make it more clear, I have made a demo job.
Input:
1.33;4
2.24;4
See my screenshots for details
Best regards
Sabrina

[Anonymous]

Okay perfect. Thanks Sabrina

[Anonymous]

Hi,
Feel free post your issue on forum.
Best regards
Sabrina

[Anonymous]

Hi,
I have to calculate average for a field in which it is necessary to ignore null values, I am using the component tAggregateRow and the input is from tMap the field is a String, but i get this message
Warning:the operation 'sum' for the output column 'MV' can't be processed because of incompatible input and/or output types

i tried to change to double but i think this will return unwanted caculations because it will consider 0 where there is actually no data, right?
how can i get a way of ignoring nulls?

[Anonymous]

Hi
Use a tFilterRow to filter the rows that are empty or null value before tAggregateRow, and convert the data type from string to a numeric type for the oeration 'sum'.
Shong

[Anonymous]

Hi,

I have negative values in my data and i want to sum up using aggregate row.  but the results are as follows.

input:

-10

20

expected output:

10

actual output:

30

can someone help me? 

[manodwhb]

@keerthi-gurudu,check the below screenshot.

[Anonymous]

 @manodwhb

my job looks as below. I have my input coming from the file using tmap to get specific columns. this case sum is not working as expected? 

can u help me to resolve this issue?

[manodwhb]

@keerthi-gurudu,in the invoiceout section,how many fields are you passing to taggregaterow?