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.
Solved! Go to Solution.
@Kinetic_analytics how do you calculate the balance manually ? By comparing the 2 rows?
@binuacs I used to do manually.
@Kinetic_analytics Can you explain the steps when you calculate manually? are you taking the difference of the consecutive 2 rows?
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.
@binuacs Thank you. Great help :)
@binuacs 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
@Kinetic_analytics If your data is already double then you don't need the multi-field formula
@binuacs Thank you :)