Adding IF Statements

[angelique_martin]

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

[christine_assaad · Accepted solution]

Hi @angelique_martin 

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

[PhilipMannering]

Just an alternative to Christine's excellent solution,

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