Basic calculations

[Polite123]

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:)

[AngelosPachis]

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

[Polite123]

Hi @AngelosPachis ,

Oops...typo error..at times copy pasting doesn't work here.

Your understanding is perfect.Please design workflow accordingly.

Thanks:)