Need Formula Calculation or guidance on how to create the field in Alteryx.

[BAvitia23]

Greetings, 

Need help in achieving this logic in Alteryx. 

IF ATTR([JC Type])='WIP_No-Etc' then MAX(NS Project Labor]) else SUM([US RU Labor])END

Some Background, the workflow is build off a ODBC connector to NetSuite, labor costs are flowing and are used in calculations, however there is a sub group of projects WIP_No-Etc where the labor is hard coded (Adjusting for WIP) so when looking at the labor if they are projects WIP_No-Etc then labor is a max, for all others it's a sum because we are adding all the transaction level details. 

And I need this to be a single column, because in the front end there is aggregation to where they can drill to a set of programs, then drill down to the project number within the program so there needs to be aggregation.

Any suggestions are greatly appreciated.

[DanielG · Accepted solution]

@BAvitia23 Is this example the concept you are going for?  I tried my best to follow what you are saying but I didnt fully get the part about the front-end.  😊

[BAvitia23]

Thank you