Issue with imputation function

[laxmikant_singisetty_dup_491]

Hi All,
Can anyone please help me with imputation function?
I used imputation in workflow to replace “NULL” with 1 in column “FX Rates Period 1” but this function is rounding off decimals in another column (Amount for Period 1).
Can anyone help on this.
Below is the screenshot workflow for reference.

[echuong1]

I can't see all of the configurations of your workflow in the screenshot, but the datatype might be changing and therefore rounding.

Try using a conditional statement in a formula to impute. In the example below, the 5.45 is what is going to be filled in if the value for the amount field is null.

IF isnull([AMOUNT FOR PERIOD 1])

THEN 5.45

ELSE [AMOUNT FOR PERIOD 1]

ENDIF 

[danilang]

hi @laxmikant_singisetty_dup_491 

Can you provide some sample data.  Just the first few rows of the result window that you show in  1.png.  

Dan

[laxmikant_singisetty]

Thank you, Tried formula instead of Imputation function and it work more accurately.