Page 1 of 1

Exponential to decimal in Aggregator

Posted: Thu Feb 16, 2006 9:59 pm
by somu_june
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.

Posted: Thu Feb 16, 2006 10:10 pm
by Nageshsunkoji
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.

Posted: Fri Feb 17, 2006 9:44 am
by somu_june
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.