We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Formulas from Excel to Alteryx

SurbhiMittal
7 - Meteor
‎03-09-2023 10:53 PM

Hi Team,

 

Please refer to the attached excel file.

 

Please go through the formulas in Columns K,L,M,N,O.I want to replicate these formulas in Alteryx so that I can get the same results.

Preview file
13 KB
Reply
1 REPLY 1
binuacs
21 - Polaris
‎03-10-2023 12:12 AM

@SurbhiMittal One way of doing this

 

Note: The Item Type2 formula is not updated, you can copy the item Type1 formula and make the changes

 

 

binuacs_0-1678435835352.png

 

ExcelFormula_100323.yxzp
ExcelFormula_100323.yxmd
Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All