DSXchange

I am doing sum on Quanity column(Using Aggregater Stage),output must be integer type,so how to get integer value after Aggregation?
Any ideas....

Regards
Beeram

In general DS treats all default numeric vales as decimals.
In Aggregator Stage output is always decimal. If you really want an Integer result you may have to type cat the result to Integer.

Go ahead and define it as Decimal n,0 on the Stage-Properties tab. This will format the value like an integer by not having the decimal or the precision.

Hi

In the Aggregator stage stage Stage-Properties input tab define it as decimal (9,0) then stage properties particular calculation column give Decimal 9,0 then Output tab once again defined as Integer. This way to get integer out put from Aggregator.

Thanks
Man

If you are passing an integer value, then you will get out put also as integer. But the out put field will be always decomal. If you want to change you can set the range of the decimal part as 0. Try it.