Alteryx Designer Desktop Discussions

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

Netting of values

harmful_virus
6 - Meteoroid

HI Team,

 

I have a simple solution in excel in Colum "Check" . Can you please provide me the same excel formula in apteryx.

 

Please Note: Column A,B & C data will be provided by the User & i only need the "check "Column to be created & required the same formula in Alteryx.

 

Please help me with solutions.

2 REPLIES 2
IraWatt
17 - Castor
17 - Castor

Hey @harmful_virus,

I think this workflow follows the logic in the Excel file:

IraWatt_0-1655233473197.png

Any questions or issues please ask :)
HTH!
Ira

 

Qiu
20 - Arcturus
20 - Arcturus

@harmful_virus 
@IraWatt gives a good flow for it

But I always feels the batch macro is a better fit for this kind of Excel functions.

We can bring each row indivisually into the macro then perform the necessary calculation.

0615-harmful_virus-1.PNG0615-harmful_virus-2.PNG

Labels