community Alteryx IO Alteryx.com
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
Free Trial

Alteryx Designer Desktop Discussions

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

If statement it's not working? why?

Aegean
5 - Atom
‎10-06-2021 05:39 PM

 

Hi Can I please ask for help that why my FTE ADJ formula it's not working? result is still 4.97?

Thanks

Aegean_0-1633566970773.png

 

Labels:
Reply
0 Likes
3 REPLIES 3
MarqueeCrew
20 - Arcturus
20 - Arcturus
‎10-06-2021 05:46 PM

@Aegean ,

 

fte appears to equal .000497

 

 cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Reply
cmcclellan
13 - Pulsar
‎10-06-2021 07:12 PM

I think Mark got it wrong (I'm guessing it's just a typo), but 4.97e-03 = 0.00497 so just a little bit above 1 - nowhere near 1.01 so it falls into your ELSE and returns the existing value

 

Always check the scientific notation 🙂 

Reply
0 Likes
Aegean
5 - Atom
‎10-06-2021 09:58 PM

Thanks you both, Yes...

Reply
0 Likes
register for community webinar
Labels