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.
Solved! Go to Solution.
@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
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%20...
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.