Add summed rows to the bottom of a balance sheet
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, first of all, I'm starting to wonder if I deserve an alteryx license. I am having such a hard time.
I'm in the process of trying to understand how to add the appropriate data into the credit column and finish adding the total sum to the bottom of the appropriate columns.
I tried using if [G/L Categories] = "60200 Salaries & Benefit : Employee Benefits" then tonumber([Debit]) else 0 endif, as recommended on a previous post but I keep getting zero for this specified field.
Then I totaled the rows in debit and credit but now I'm trying to remember how to add them on the bottom of the appropriate columns.
Attached I have a screenshot of what the balance sheet is supposed to look like, the data set from my workflow and the workflow.
 
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @jalizmaldonado,
In order to add some kind of data at the bottom of your data you need to use the union tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @jalizmaldonado,
Great to hear that. 🙂
I see that the union tool helped you with your problem.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
As recommended, I've unioned the data and add the debit/credit totals to the correct columns. Please see attached.
