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

[patrick_digan]

@Escaped_Goat There are numerous ways to accomplish this. I've chosen to use a multi-field tool and a formula tool. A single formula tool would have worked as well. I've attached my alteryx file.

[Escaped_Goat]

Thank you for replying so quickly. Unfortunately I am unable to open your workflow as running 32 bit version until my laptop is upgraded. I will have a play with the multi-field tool and see how I get on

[estherb47 · Accepted solution]

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

[Escaped_Goat]

Thank you! that worked :-)