Crosstab Output: Set NULL to Zero

[amweir]

Hello,

How do I set the NULL values in the attached Crosstab output to zero?

The green column does not have values that go out to the dates in the first column so Alteryx sets the values to NULL.

Thank you.

[rzdodson · Accepted solution]

@amweir one approach I have used is applying a Multi-Field Formula tool after the Cross Tab. From here, select the numeric fields you want to change from null to zeroes. Then, in the MFF's formula syntax, you should be able to apply the below to set them all to zeros:

IF ISNULL([_CurrentField_]) THEN 0 ELSE [_CurrentField_] ENDIF

[amweir]

Thank you @rzdodson.  That worked.