We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Formula leaving field blank for random records?

CDIns
8 - Asteroid
‎07-19-2024 12:02 PM

Please see attached. I've ran this workflow about a week ago and this did not happen. Nothing has changed to my workflow. I just re-ran it and the formula to calculate book value is leaving some records blank despite having values that would calculate a book value. Any ideas? Is this a bug? 

 

Thank you!

Preview file
92 KB
Reply
0 Likes
1 REPLY 1
CDIns
8 - Asteroid
‎07-19-2024 12:11 PM

Following up - The records that I was seeing this happen to had NULLS in the fields used to calculate book value. I added data cleanse to replace nulls with 0s and it works again. 

 

 

Reply
Live Office Hours
Labels
Top Solution Authors
View All