Basic calculations

Question

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:

CDE F   159,770,665 159,466,437  304,228   45,174,614      A     TOTAL           B           Difference

Output:

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

Polite123 · Answer

Hi @AngelosPachis ,

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

Your understanding is perfect.Please design workflow accordingly.

Thanks:)

AngelosPachis · Answer

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