Hi,
Can anyone help how to write this on alteryx
=SUMIFS($B$1:$B$2,$A$1:$A$2,B3,$C$1:$C$2,"<>-")
Test data
Order Number | Accounting colour amount | Booking flag |
2561895 | -218,599 | Closed |
2561895 | 218,599 | Closed |
2571480 | -7,627,360 | Closed |
2571480 | 0 | Closed |
2571480 | 7,627,360 | Closed |
2571480 | 0 | Closed |
2583986 | -152,859 | Closed |
2583986 | 0 | Closed |
2583986 | -13,500 | Closed |
Your Excelformula is a bit weird. Your criteria for range 1 is set at the title order number and only B3 moves along your rows, it's doesn't make to much sense to me. What is your goal?
Do you want to sum the next value in column B if not 0 value AND if Order number is the same AND Booking flag is the same?
In that case the sum of all @ order 2583986 would not be zero.
If you can explain it, i can surely make it for you :-)!
Greetings,
Seb
Hi @Amy123,
I agree with @Sebastiaandb it's a little difficult to know exactly what you're looking for as the formula doesn't seem to be working logically, but i would be taking an approach along this line:
I've attached my workflow for you to download if needed!
Kind regards,
Jonathan