Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Multi Field Formula Changing Data Types?

Bonediggler
9 - Comet

Experts!

 

Weird problem here.  I am using a Multi Field Formula tool to set a couple of measures (data type double) to 0 if a particular dimension is NULL.  However upon inspecting the output the values are rather being set to -1, which seems to imply Alteryx is interpreting the multi-field logic as boolean?  Having said that, the data type of the measures after passing through the multi-field logic is still double. 

 

Is this a known bug?  Am I missing something here?  Here is the multi-field code (sorry I cannot upload the wf): 

 

If IsNull([dimension]) 
Then [_CurrentField_] = 0
Else [_CurrentField_]
EndIf

 

 

Thanks for the help!

1 REPLY 1
Jean-Balteryx
16 - Nebula
16 - Nebula

Hi @Bonediggler ,

 

I think you just have to use

 

Then 0

 

 instead of

Then [_CurrentField_] = 0

 

Cheers,

 

Jean-Baptiste 

Labels