How to create new columns based on a single criteria efficiently?

Hello,

For the below image, I need to create multiple new columns (it can be Total Number, Total Count, Total/count etc).
All those new columns should be based on a single logic i.e It should only be based on column Name which have ESOP as its value.

How can I try to use the Formula tool in an efficient way?

I have attached the workbook for reference.

alteryx excel.xlsx

Developer Tools

Designer Cloud

Preparation

Data Investigation

Accepted answers

IraWatt

Hey @madhurinani,

Okay all you need to do is use a formula tool like this:

The community has some quick and easy videos on formulas and the Formula Tool here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Writing%20Expressions

Workflow.yxmd

Amol_Telore

Hey @madhurinani

One way of doing this, use IF ELSE formula.

All comments

IraWatt

Hey @madhurinani,

Here is one way to do this:

Any questions or issues please ask
HTH!
Ira

Workflow.yxmd

madhurinani

@IraWatt :

This is not what I was expecting.

Let me provide you a better example.

See the below pic.

Taking example from Group A--

Like New column 1 could be 7/3

New column 2 would be 7+3

New column 3 would be 7-3

All these calc should only work for the row which has ESOP in the Name column.

I want something like a global formula that only runs for ESOP and then calc the new column.

Or if you could help me figure out how can i create a formula which creeates New Column 1 (addition of 7+3) only for ESOP records

IraWatt

Hey @madhurinani,

Okay all you need to do is use a formula tool like this:

The community has some quick and easy videos on formulas and the Formula Tool here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Writing%20Expressions

Workflow.yxmd

Amol_Telore

Hey @madhurinani

One way of doing this, use IF ELSE formula.

madhurinani

Thanks @Amol_Telore and @IraWatt .

Both your logic makes sense. I still need to use the ESOP condition always in my multi field formula.

Thanks for your help.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703