informatica - Expression to replicate Aggregator -

i need replicate below piece of sql expression in informatica column1 decimal(25,6) :

replace(round(coalesce(trim(l '0' column1),0),0),'.000000','') 

i tried using below in aggregator expression :

iif(isnull(column1),0,(round(ltrim(column1,0),0))) 

encountered below error when validated same:

[round]: operand cannot converted number

please me fix issue

it's failing coz applying string function ltrim column1 implicitly converting string , applying round string.

a way solve use round. since column1 decimal, don't need strip left zeroes won't there.