Journal Entry - Moving Numbers between Debit and Credit

[jalizmaldonado]

Hi, I hope all is well. 

I'm currently in the process of moving a number that is in the debit column to the credit column so that I can then add the correct totals for debit and credit. 

To move the debit to credit, I created the following formula which didn't work. Not sure what I did incorrectly.

IF [G/L Categories] = "60200 Salaries & Benefit : Employee Benefits" THEN [Sum_Value] = [Credit] ELSE "" ENDIF

Then I tried to add the debit/credit column by using the Multi-Row Formula tool but I couldn't figure out how to add the entire column and provide me with a total amount on the bottom of the column. 

Please help. Also, if there are any formula how-to videos, please share.

  

 

[messi007]

@jalizmaldonado,

Could share the Excel file please.

Regards

[jalizmaldonado]

@messi007 

Attached is the excel sheet.

[jalizmaldonado · Accepted solution]

I was finally able to solve it. I filtered out the credit inputs. Please see attached workflow for the solution.