Hello experts, I need your help creating a workflow. I’m trying to perform a subtraction function between two columns. I have attached a sample excel spreadsheet with demo numbers with the expected result in column “E” SY2. * It’s basically the difference between two columns. However, if it’s a balance sheet type of accounts (series 1-3), we only pick up the ending balance from column D (no difference needs to be calculated). * If it’s an income statement accounts (series 4-8), we take the difference between column D-C. Hope you can help. This forum never let me down. Sample for Forum.xlsx

Workflow to perform a subtraction between two columns with a bit of twist.

Hello experts,

I need your help creating a workflow. I’m trying to perform a subtraction function between two columns. I have attached a sample excel spreadsheet with demo numbers with the expected result in column “E” SY2.

It’s basically the difference between two columns. However, if it’s a balance sheet type of accounts (series 1-3), we only pick up the ending balance from column D (no difference needs to be calculated).