Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

column calculation

Escaped_Goat
7 - Meteor

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_DateAMPM
04/02/2014On TerritoryOn Territory
02/01/2013Meeting otherMeeting other
17/01/2016WeekendWeekend
10/02/2013WeekendWeekend
09/10/2014On TerritoryOn Territory
07/05/2012Bank HolidayBank Holiday
07/05/2017WeekendWeekend
08/01/2017WeekendWeekend
20/03/2014On TerritoryOn Territory

 

 

4 REPLIES 4
patrick_digan
17 - Castor
17 - Castor

@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
7 - Meteor

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
15 - Aurora
15 - Aurora

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
7 - Meteor

Thank you! that worked :-)

Labels