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:)
Hi @Polite123 ,
There are missing values in your input, which is what prevents me to answer your solution.
For example, is 2 the result of a subtraction between 159770667-159770665? If yes then 159770667 should be in your input. If not and for some reason the value 2 was a value you had at your disposal, then that should be placed in your input right after A so we can go on and calculate
159770667- 2= 159770665
The same is valid for the rest of the columns, so probably you should try and refine the input you have provided and what's your desired output.
Hope that helps,
Angelos
Hi @AngelosPachis ,
Oops...typo error..at times copy pasting doesn't work here.
Your understanding is perfect.Please design workflow accordingly.
Thanks:)