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!
Solved! Go to Solution.
Hi @Bonediggler ,
I think you just have to use
Then 0
instead of
Then [_CurrentField_] = 0
Cheers,
Jean-Baptiste
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |