community Alteryx IO Alteryx.com
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
Free Trial

Alteryx Designer Desktop Discussions

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

Multi-Row Formula translation from Excel

carterfleming
8 - Asteroid
‎02-13-2023 11:44 AM

How would I convert this Excel formula into Alteryx? 

carterfleming_0-1676317426503.png

 

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
ShankerV
17 - Castor
‎02-13-2023 11:48 AM

Hi @carterfleming 

 

Please use, 

 

IF ([Row-1:F1]="Yes" AND [Row-1:F2]="NO")

THEN [F3]+[F4]

ELSE 0

ENDIF

Reply
0 Likes
ShankerV
17 - Castor
‎02-13-2023 11:51 AM

Hi @carterfleming 

 

Please find the expected output.

 

ShankerV_0-1676317840836.png

 

Many thanks

Shanker V

Multi-Row Formula translation from Excel.yxmd
Reply
learn more about the python upgrade coming in may 2024
Labels