SOLVED
Multi Field Formula Changing Data Types?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Bonediggler
9 - Comet
‎09-01-2020
07:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Bug
1 REPLY 1
16 - Nebula
‎09-01-2020
08:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Bonediggler ,
I think you just have to use
Then 0
instead of
Then [_CurrentField_] = 0
Cheers,
Jean-Baptiste
