Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
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
Free Trial

Alteryx Designer Desktop Discussions

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

Adding IF Statements

angelique_martin
7 - Meteor
‎10-01-2021 02:52 PM

Hi Alteryx community,

 

I am having difficulty on writing an if formula that includes some addition within Alteryx. I have attached a screenshot of the outcome I'm trying to get for the YTD Netoff Column. Any help will be greatly appreciated. Thanks

 

angelique_martin_0-1633124978908.png

 

 

 

Preview file
13 KB
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
christine_assaad
Alteryx
Alteryx
‎10-01-2021 03:25 PM

Hi @angelique_martin 

 

Please check the below screenshot. Hope that helps. Cheers!

 

christine_assaad_0-1633127125785.png

 

Reply
PhilipMannering
16 - Nebula
16 - Nebula
‎10-02-2021 02:41 AM

Just an alternative to Christine's excellent solution,

(1 - [Include MF]) * [YTD FE] +
(1 - [Include WR]) * [YTD WE] +
(1 - [Include CS]) * [YTD Cost SE]

 

Reply
register for inspire
designer new user guide
Labels
Top Solution Authors
View All