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.
Exponential to decimal in Aggregator
Moderators: chulett, rschirm, roy
Exponential to decimal in Aggregator
somaraju
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
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.
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.
NageshSunkoji
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
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.
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.
somaraju