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 Number | Accounting colour amount | Order Bal | SUMIFS($B$1:$B$1,$A$1:$A$1,A1) | |
5085980 | 200,000 | 0 |
Can you re-phrase the question?
Is this an accurate description of the problem:
You have 14 rows of data. You want to calculate a sum of column B for only the first 10 rows of data, where the value in column A equals the value in cell A2?
Chris
If in excel you use this formula the Order bal will be Zero.
I want the same in alteryx.
Order Number | Accounting colour amount | Order Bal | SUMIFS($B$1:$B$2,$A$1:$A$2,A1) | |
5085980 | 200,000 | 0 |
Hi @Amy123 , please make sure you have the summarize tool configured as per and the answer will be 0: