Hi Team,
I need some help in with basic calculations in an organized format as shown below.
Please focus on values
B row==Value of E1(304228) + Value of E2(0)
A=2 MEANS 159770667-159770665
Input:
C | D | E | F | ||
159,770,665 | 159,466,437 | 304,228 | 45,174,614 | ||
A | |||||
TOTAL | |||||
B | |||||
Difference |
Output:
C | D | E | F | ||
159,770,665 | 159,466,437 | 304,228 | 45,174,614 | ||
A | 2 | 0 | - | ||
TOTAL | 159,770,667 | 45,174,614 | |||
B | 304,228 | ||||
Difference | 2 | - |
Any help would be highly appreciated
Thanks in advance:)
I would start with checking out the Tool Mastery Index (https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Index/ta-p/84593) for the Multi-Row tool.