[resolved] Exception in component tAggregateRow (BigDecimal average&sum)

[Anonymous]

Hi
search in several forums, but cannot find how to resolve my aggregation bug :
Exception in component tAggregateRow_1_AGGOUT
java.lang.NumberFormatException
at java.math.BigDecimal.<init>(Unknown Source)
at java.math.BigDecimal.<init>(Unknown Source)

In the tMap :
- I first transform the Integer columns into BigDecimal (define variables to do that) :
Var.NbrSonnAbouti:
row1.DUREE_SONN_ABOUTI==null?null:new BigDecimal(row1.DUREE_SONN_ABOUTI)
- Then a division is performed on 2 columns in the right editor :
For NBR_SONNERIES_ABOUTI column :
Var.NbrSonnAbouti==null?null:Var.NbrSonnAbouti.divide(new BigDecimal(5),2,BigDecimal.ROUND_CEILING)
Same for NBR_SONNERIES_NON_ABOUTI column

[Anonymous · Accepted solution]

Resolved.
The 'Ignore null values' have to be checked for all the colums in the tAggregate (first, I've checked only the average ones)

[Anonymous]

Hi,
Thanks for the feedback devkl!
Best,
Pcoffre.

[Anonymous]

what is the difference between tAggregateRow and tCombinedSQLAggregate can you please explain with example

[Anonymous]

Hi chandu.jayaprada,
Could you please open a new topic? Your issue is not related to current one.
Best regards
Sabrina

[klongid]

Thank you. This helped resolve my issue