Netting of values

Question

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.

Excel solution.xlsx

Qiu · Answer

@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.yxzp

IraWatt · Answer

Hey @harmful_virus,

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

Any questions or issues please ask :)
HTH!
Ira

Workflow.yxmd