How to make sure debit and credit side are the same before generating output?

[wenyg]

Hi, what tool should I use if I want to make sure debit and credit side are the same before generating output?

[alexnajm]

Hi @wenyg,

It highly depends on the structure of your data, but I would put a Filter tool down afterwards and set the custom query to be [Debit] = [Credit]. Anything that matches this will drop out of the T anchor, and anything that doesn't will drop out of the F anchor!

-Alex

[alexnajm]

You could also round if there are a lot of decimals - Round([Debit],0.01) = Round([Credit],0.01)

Also if you wanted a column reporting the difference between the two, you could use a Formula tool to calculate ABS([Debit] - [Credit]) and then use the Filter afterwards to find where [Difference] > 0 or whatever threshold you feel comfortable with.

[wenyg]

Hi alex, I did try using filter tool, but shown as invalid

[alexnajm · Accepted solution]

Hi @wenyg,

Are those the exact names of the debit/credit fields on your side? I just put generic names but the [Debit] field should match the column name of your Debit column - for example, if it's named [debits] then make sure it reflects as such in the Formula. Same thing with Credits as well!

In addition, make sure the fields are both numeric and not strings - typically these are stored as Double but could be stored as FixedDecimal or Float. You can check the Metadata in the Results pane quickly or put down a Select tool in between the Union and the Filter.

If you want more direct help on the workflow, go ahead and "Export Workflow" under Options - this will package the workflow and any relevant data together into a .yxzp file. Make sure to redact any sensitive data!