Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How can I write a formula to offset balance

Kinetic_analytics
11 - Bolide

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.

9 REPLIES 9
binu_acs
21 - Polaris

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

Kinetic_analytics
11 - Bolide

@binu_acs I used to do manually. 

binu_acs
21 - Polaris

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

Kinetic_analytics
11 - Bolide

@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
21 - Polaris

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

 

binuacs_0-1678221819164.png

 

Kinetic_analytics
11 - Bolide

@binu_acs Thank you. Great help :)

Kinetic_analytics
11 - Bolide

@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
21 - Polaris

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

Kinetic_analytics
11 - Bolide

@binu_acs Thank you :)

Labels
Top Solution Authors