Sumifs in alteryx

Question

@ChrisTX @JoeHerbert

If in excel you use this formula the Order bal will be Zero.

Joe, I used the summarize tool and then the order Bal turn to 200,000 this is not correct as per logic.

Order NumberAccounting colour amountOrder BalSUMIFS($B$1:$B$1,$A$1:$A$1,A1)5085980200,0000

JoeHerbert · Answer

@Amy123 please could you mark the solution as accepted and I can close this off?

Thanks

JoeHerbert · Answer

Hi @Amy123 , please make sure you have the summarize tool configured as per and the answer will be 0:

Amy123 · Answer

@ChrisTX

If in excel you use this formula the Order bal will be Zero.

I want the same in alteryx.

Order NumberAccounting colour amountOrder BalSUMIFS($B$1:$B$2,$A$1:$A$2,A1)5085980200,0000