Exponential to decimal in Aggregator

somu_june · Post by **somu_june** » Thu Feb 16, 2006 9:59 pm

Hi,

Iam aggregating records and getting output from aggregator as 1.988855e07. I want answer as decimal like this 19888555.00. since aggregator . I gave input to aggregator as double 30,2 and output as double 30,2.

Thanks,
Somaraju.

Nageshsunkoji · Post by **Nageshsunkoji** » Thu Feb 16, 2006 10:10 pm

Hi,

In such type of cases you have to set the option in the aggregator Default to decimal output as [30,2], then you can get your expected result. The default value for Default to decimal output is [8,2]. So, change the settings in the above mentioned option. I think this will solve your problem.

Thanks & Regards
Nagesh.

somu_june · Post by **somu_june** » Fri Feb 17, 2006 9:44 am

Hi Nagesh,

Thanks for reply, My problem was solved . I gave input to aggregate stage as decimal (12,2) and output to aggregate stage as decimal (12,2) and I selected decimal output in aggregate stage instead of (8,2 default) I gave as (12,2). Now Iam getting my value as I required Like this 123456789.12.

Thanks,
Somaraju.