How can I write a formula to offset balance

[Kinetic_analytics]

Hello Great minds:

If balance is the exact same (to the penny) including differing signs, filter out of dataset as balanced if not then not balanced.

Balance

393,025.50

-393,025.50

137.88
229.58
-0.03
-200,333.98
2,674.60
-2,878.65
109,937.98
-109,733.94
-576.27
60,509.66
-59,933.38
13,404.70
-13,270.01
210,763.54
-210,898.24
-125,953.37
150,850.20
-20,087.14
164,425.52
-169,235.20
80,405.65
-856.39
-72,681.63
21,384.90
-28,252.51
386,198.95
-386,198.95

Appreciate your help in my learning process.

[binu_acs]

@Kinetic_analytics how do you calculate the balance manually ? By comparing the 2 rows?

[Kinetic_analytics]

@binu_acs I used to do manually. 

[binu_acs]

@Kinetic_analytics Can you explain the steps when you calculate manually? are you taking the difference of the consecutive 2 rows? 

[Kinetic_analytics]

@binu_acs 

in the current excel filter those data by considering the fact: If any balance exactly positive and negative matches exact to the point level then those balance are considered as matched. If not matched then need to investigate why those numbers are not matching. 

[binu_acs · Accepted solution]

@Kinetic_analytics I am thinking some like this. Let me know if that works for you

[Kinetic_analytics]

@binu_acs Thank you. Great help :)

[Kinetic_analytics]

@binu_acs  another quick question how do you edit the formula in the Multi- Field formula tool if the Data is already Double? I refer this formula: 

 toNumber(REplaceChar([_CurrentField_],',',''))

Appreciate your response. 

Thanks

[binu_acs · Accepted solution]

@Kinetic_analytics If your data is already double then you don't need the multi-field formula

[Kinetic_analytics]

@binu_acs Thank you :)