column calculation

Escaped_Goat

Hi

I am new to Alteryx and have the following question. I would like to show a new column in the table where AM is On Territory = 0.5 and PM is On Territory = 0.5 and Full Day = sum of both. Where AM and PM <> On Territory = 0.

E.G. 04/02/2014 AM 0.5, PM 0.5, Full Day 1

        17/01/2016 AM 0, PM 0, Full Day 0

Hope this makes sense. Thanks

Close_Date	AM	PM
04/02/2014	On Territory	On Territory
02/01/2013	Meeting other	Meeting other
17/01/2016	Weekend	Weekend
10/02/2013	Weekend	Weekend
09/10/2014	On Territory	On Territory
07/05/2012	Bank Holiday	Bank Holiday
07/05/2017	Weekend	Weekend
08/01/2017	Weekend	Weekend
20/03/2014	On Territory	On Territory

estherb47

Hi!

Use a formula tool to create a new field, called Full Day (data type needs to be numeric)

IIF([AM]="On Territory", .5, 0) + IIF([PM]="On Territory", .5, 0)

This subsitutes a 0.5 for On Territory, and a 0 for everything else. Haven't tested it, but it should work.

Best,
Esther