Issue with imputation function

Question

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.

1.png

2.png

laxmikant_singisetty · Answer

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

danilang · Answer

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

echuong1 · Answer

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