Create a new FixedDecimal field from an existing FixedDecimal field

vern

I am trying to create a FixedDecimal field from an existing FixedDecimal field if another field equals a certain value

I am fairly new to Alteryx and cannot determine what I am doing wrong.

I just want to create a 2nd field from the original field 'WAGE_AMOUNT'

Best Practices

Accepted answers

annedione

Hi @vern

I think your issue comes from the ELSE statement. you're trying to create a numeric field therefore you want to make sure that the condition you state also match a numerical condition. Assuming [WAGE_AMOUT] is a numeric field, therefore replacing the quotes by a 0 would make more sense.

Thx

All comments

atcodedog05

Hi @vern

Change Else "" to Else Null()

IF [PAY_SUM_GRP] = "HO1"

THEN [WAGE_AMOUNT]

ELSE Null()

ENDIF

"" is a string datatype hence its creating error. Null() is datatype independent which leaves the value blank.

Hope this helps : )

annedione

Hi @vern

Thx

vern

The only remaining issue is when I use the sum function in Excel to total the original field I get a valid total; however, when I use the sum function to total the new field I get a total of 0?

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335