# 34|ALTERYX – Audit Attention **URL:** https://www.techhub.training/t/34-alteryx-audit-attention/579 **Category:** Challenges **Tags:** beginner, alteryx, audit **Created:** [May 1, 2023, 6:53pm UTC](https://www.techhub.training/t/34-alteryx-audit-attention/579 "2023-05-01T18:53:12Z") **Posts on this page:** 20 **Page:** 1
### Author: ![DylanKing](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/dylanking/32/25_2.png) [@DylanKing](https://www.techhub.training/u/DylanKing) #### Post date: [May 1, 2023, 6:53pm UTC](https://www.techhub.training/t/34-alteryx-audit-attention/579/1 "2023-05-01T18:53:12Z")
_BYU Student Author_: @DylanKing _Reviewers_: @Christian, @Boston, @Alex_Garrett _Estimated Time to Solve:_ 10 Minutes We provide the solution to this challenge using: - Alteryx - [Go here to perform this challenge in SQL](https://www.techhub.training/t/34-sql-audit-attention/281/8) Need a program? Click [here](https://www.techhub.training/t/information-about-software-used-on-techhub-training/138). **Overview** This challenge works in connection with [Challenge 52|ALTERYX – Balance Sheet Boost](https://www.techhub.training/t/52-alteryx-balance-sheet-boost/193). As a first-year associate who recently graduated from school, you have joined a small local accounting firm in the area. Your first assignment is to audit the Financial Statement Controls of a local chain of car repair shops. The senior member of the engagement team informed you that they had strengthened the controls around the income statement in the previous year. However, they remain concerned about some of the controls around certain balance sheet accounts that do not meet the firm’s standards. You decide to use your skills in Alteryx to identify balance sheet accounts that require the most attention during the audit. After meeting with others on the engagement team, you determine that accounts that have 1,000 transactions or more during the month and have an ending debit or credit balance of 50,000 or more will require the most attention. You notify the other members of the audit engagement that you will find which accounts meet these criteria. **Instructions** Using Alteryx, create a workflow to identify which accounts meet the aforementioned criteria. Remember, accounts must have 1,000 transactions or more and have an ending debit or credit balance of 50,000 or more. Sort by the number of transactions in descending order and be sure to sort out the data that has a null account number. In the end, your output should have the following columns: Acct, GLAcctDesc, EndingDebitBalances, NumOfTransactions. **Data Files** - [Challenge34\_Audit\_Attention.xlsx](https://byu.box.com/shared/static/yg4o5diwu3azfieyc9pg2exy8dbzzff3) - [Challenge34\_Data\_Dictionary.docx](https://byu.box.com/shared/static/7fz36tlpzksou884ni9uxs1ohshc43ku) > **Suggestions and Hints** > > When trying to find the accounts that follow the criteria of having an ending debit or credit balance of $50,000 or more, remember that we are given the ending debit balance. Using absolute value can help you get around this problem. **Solution** > **Solution Image** > > ![Challenge34_Solution_Image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/1X/16720e27556f779aab144a9088225b506d5b149e.png) [Challenge34\_Solution.yxmd](https://byu.box.com/shared/static/lutkybh5lcqsyk09ipxk634xvalhg52d) _Solution Video:_ [Challenge 34|ALTERYX – Audit Attention](https://youtu.be/dxH7-gyUQTg) ---
### Author: ![Benjamin\_Lau](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/benjamin_lau/32/379_2.png) [@Benjamin\_Lau](https://www.techhub.training/u/Benjamin_Lau) #### Post date: [May 16, 2023, 5:43pm UTC](https://www.techhub.training/t/34-alteryx-audit-attention/579/2 "2023-05-16T17:43:43Z")
Thank you Dylan again for the great challenge! Here is my solution: ![Challenge 34 Solution](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/1X/390f297853184dded29c52b70e431d4aa67598e9.jpeg) ---
### Author: ![TylerBooth](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/tylerbooth/32/335_2.png) [@TylerBooth](https://www.techhub.training/u/TylerBooth) #### Post date: [May 23, 2023, 5:53pm UTC](https://www.techhub.training/t/34-alteryx-audit-attention/579/3 "2023-05-23T17:53:55Z")
Great refresher challenge! My solution came out just about the same as yours. I initially forgot to set the first filter to catch the credit balances. I just saw the column header, “EndingDebitBalance” and assumed the number would all be positive. Thanks for writing this challenge Dylan! ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/1X/9f6457d6782720e28146d154acdab8a34c132927.png) ---
### Author: ![Katie\_Morgan](https://avatars.discourse-cdn.com/v4/letter/k/f17d59/32.png) [@Katie\_Morgan](https://www.techhub.training/u/Katie_Morgan) #### Post date: [November 1, 2023, 5:56pm UTC](https://www.techhub.training/t/34-alteryx-audit-attention/579/4 "2023-11-01T17:56:39Z")
![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/9/9b9f333c6dbfcac46569cc8003ed65ba40ed9b86.png) I forgot how important the absolute value would be. Great challenge! ---
### Author: ![Katie\_Morgan](https://avatars.discourse-cdn.com/v4/letter/k/f17d59/32.png) [@Katie\_Morgan](https://www.techhub.training/u/Katie_Morgan) #### Post date: [November 1, 2023, 6:30pm UTC](https://www.techhub.training/t/34-alteryx-audit-attention/579/5 "2023-11-01T18:30:00Z")
[TechHub3.yxmd](https://www.techhub.training/uploads/short-url/kdH5gKBM6ZPm7oPmcOi7OAmkjXK.yxmd) (14.7 KB) ---
### Author: ![Mimi\_Haddock](https://avatars.discourse-cdn.com/v4/letter/m/67e7ee/32.png) [@Mimi\_Haddock](https://www.techhub.training/u/Mimi_Haddock) #### Post date: [November 1, 2023, 8:27pm UTC](https://www.techhub.training/t/34-alteryx-audit-attention/579/6 "2023-11-01T20:27:14Z")
![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/6/619ac990489d1cc3c28baa477aeae21702e520c5.png) [TechHub1.yxmd](https://www.techhub.training/uploads/short-url/psBHyCtk8TUHgNYMppempHWCVxr.yxmd) (14.6 KB) Thanks for the great challenge! ---
### Author: ![Spencer\_Fleming](https://avatars.discourse-cdn.com/v4/letter/s/8797f3/32.png) [@Spencer\_Fleming](https://www.techhub.training/u/Spencer_Fleming) #### Post date: [November 1, 2023, 10:52pm UTC](https://www.techhub.training/t/34-alteryx-audit-attention/579/7 "2023-11-01T22:52:26Z")
I really enjoyed this challenge! Below is my method for completing it. ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/d/df0e41d95e0e30c30b502b7d90efb616637e39ca.png) [AuditChallenge.yxmd](https://www.techhub.training/uploads/short-url/wrky7zFqrpjsU6TcCUwRpoe0Ai3.yxmd) (13.8 KB) ---
### Author: ![Alex\_Pence](https://avatars.discourse-cdn.com/v4/letter/a/ea666f/32.png) [@Alex\_Pence](https://www.techhub.training/u/Alex_Pence) #### Post date: [November 1, 2023, 10:52pm UTC](https://www.techhub.training/t/34-alteryx-audit-attention/579/8 "2023-11-01T22:52:30Z")
[TechHub1.yxmb.yxmd](https://www.techhub.training/uploads/short-url/kla4CEFmd1rX0tZRULMMoKAtek4.yxmd) (13.7 KB) ![TechHub1](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/0/0a12d88b9a66d62cffd41fc5a3ae13a0fa3190e6.png) ---
### Author: ![Andrew\_Faust](https://avatars.discourse-cdn.com/v4/letter/a/a9a28c/32.png) [@Andrew\_Faust](https://www.techhub.training/u/Andrew_Faust) #### Post date: [November 1, 2023, 10:53pm UTC](https://www.techhub.training/t/34-alteryx-audit-attention/579/9 "2023-11-01T22:53:25Z")
![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/0/012945aef296e38c4f4f260eea398ff4b756ce42.png) [TechHub34Solution.yxmd](https://www.techhub.training/uploads/short-url/h5zv6YLb8dOkPKezBNMvjZJQUxo.yxmd) (15.3 KB) Handy test to learn things ---
### Author: ![Izaac\_McCann](https://avatars.discourse-cdn.com/v4/letter/i/edb3f5/32.png) [@Izaac\_McCann](https://www.techhub.training/u/Izaac_McCann) #### Post date: [November 1, 2023, 11:05pm UTC](https://www.techhub.training/t/34-alteryx-audit-attention/579/10 "2023-11-01T23:05:29Z")
![Screenshot 2023-11-01 165817](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/b/b8cd584ce5808c7f48ecf9dc865e9fb680adcae3.png) [TechHubWorkflow1.yxmd](https://www.techhub.training/uploads/short-url/90uMWtAF0WJ7EJCpQXZ6ppGMjzL.yxmd) (15.8 KB) ---
### Author: ![Zach\_Gardner](https://avatars.discourse-cdn.com/v4/letter/z/22d042/32.png) [@Zach\_Gardner](https://www.techhub.training/u/Zach_Gardner) #### Post date: [November 1, 2023, 11:57pm UTC](https://www.techhub.training/t/34-alteryx-audit-attention/579/11 "2023-11-01T23:57:15Z")
![Screenshot 2023-11-01 175126](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/d/d179bd35b580218c14bd8a27a9e1243b6ef08bdb.png) [AuditAttention.yxmd](https://www.techhub.training/uploads/short-url/93NDYWmqi8YG9mLx4fMsKe14Iwm.yxmd) (16.5 KB) ---
### Author: ![Riley\_Judy](https://avatars.discourse-cdn.com/v4/letter/r/d6d6ee/32.png) [@Riley\_Judy](https://www.techhub.training/u/Riley_Judy) #### Post date: [November 1, 2023, 11:57pm UTC](https://www.techhub.training/t/34-alteryx-audit-attention/579/12 "2023-11-01T23:57:26Z")
![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/6/61d38ad6e6a495d66e556eaf85121d605b96578d.png) [AuditAttention.yxmd](https://www.techhub.training/uploads/short-url/gx92PpxVwlaAOPpI3p5rPrlZUA.yxmd) (16.7 KB) ---
### Author: ![mdharley](https://avatars.discourse-cdn.com/v4/letter/m/d26b3c/32.png) [@mdharley](https://www.techhub.training/u/mdharley) #### Post date: [November 1, 2023, 11:57pm UTC](https://www.techhub.training/t/34-alteryx-audit-attention/579/13 "2023-11-01T23:57:38Z")
![SS](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/a/a28a239bad840e7e2e38644c767aa2077b6b6838.png) [Aduit Attention 34.yxmd](https://www.techhub.training/uploads/short-url/odjJ2WWFWpv1iiTwtHP5jf5qrVI.yxmd) (17.3 KB) ---
### Author: ![Reece\_Clark](https://avatars.discourse-cdn.com/v4/letter/r/f05b48/32.png) [@Reece\_Clark](https://www.techhub.training/u/Reece_Clark) #### Post date: [November 2, 2023, 2:36am UTC](https://www.techhub.training/t/34-alteryx-audit-attention/579/14 "2023-11-02T02:36:09Z")
![Screenshot 2023-11-01 203351](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/0/0084f32aa8475f8a20cd6e9f40f21f85f586fece.png) [Audit Attention.yxmd](https://www.techhub.training/uploads/short-url/ygrvTwez2med9HJuF0BS4N2rLxk.yxmd) (16.3 KB) This was good practice for me! ---
### Author: ![Meg\_McEachern](https://avatars.discourse-cdn.com/v4/letter/m/c67d28/32.png) [@Meg\_McEachern](https://www.techhub.training/u/Meg_McEachern) #### Post date: [November 2, 2023, 2:55am UTC](https://www.techhub.training/t/34-alteryx-audit-attention/579/15 "2023-11-02T02:55:04Z")
[solution 1.yxmd](https://www.techhub.training/uploads/short-url/6Uh3mo6LHPtTqqxjaEUWb9xiMka.yxmd) (12.7 KB) Thanks for the challenge! Here was my solution ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/0/00ee56251c54eea5e1d819b0b92b5d85d947244b.png) ---
### Author: ![Dakin\_Rust](https://avatars.discourse-cdn.com/v4/letter/d/838e76/32.png) [@Dakin\_Rust](https://www.techhub.training/u/Dakin_Rust) #### Post date: [November 2, 2023, 2:56am UTC](https://www.techhub.training/t/34-alteryx-audit-attention/579/16 "2023-11-02T02:56:18Z")
Good one! ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/3/3c01d48b423cf0106fa0be9d72baab59f87007fe.png) [Challenge 34 Workflow.yxmd](https://www.techhub.training/uploads/short-url/9IccCMIahLIFcfwB9wJ33XWdne1.yxmd) (14.5 KB) ---
### Author: ![Megan\_Bassett](https://avatars.discourse-cdn.com/v4/letter/m/f08c70/32.png) [@Megan\_Bassett](https://www.techhub.training/u/Megan_Bassett) #### Post date: [November 2, 2023, 3:33am UTC](https://www.techhub.training/t/34-alteryx-audit-attention/579/17 "2023-11-02T03:33:22Z")
![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/8/8ccfecf769e39d9efbf06c53223897e7e55398b6.png) Here is my solution! [TechhubAlteryx2.yxmd](https://www.techhub.training/uploads/short-url/aD5Oj3vZ64WGf1y4gjzBqhBQKmG.yxmd) (16.4 KB) ---
### Author: ![Abbie\_Nielson](https://avatars.discourse-cdn.com/v4/letter/a/e47c2d/32.png) [@Abbie\_Nielson](https://www.techhub.training/u/Abbie_Nielson) #### Post date: [November 2, 2023, 3:37am UTC](https://www.techhub.training/t/34-alteryx-audit-attention/579/18 "2023-11-02T03:37:37Z")
![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/7/7cccf7c82d5913d920945830b15828e7d340f57b.png) [New Workflow1.yxmd](https://www.techhub.training/uploads/short-url/b7ZLml7c0OqawsJjd925dzpDdtY.yxmd) (54.6 KB) ---
### Author: ![Canyon\_Esplin](https://avatars.discourse-cdn.com/v4/letter/c/e495f1/32.png) [@Canyon\_Esplin](https://www.techhub.training/u/Canyon_Esplin) #### Post date: [November 2, 2023, 3:52am UTC](https://www.techhub.training/t/34-alteryx-audit-attention/579/19 "2023-11-02T03:52:27Z")
![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/1/1ce5c2f9fc28a1859fa19ed0b7a13d4f53f8e3d0.png) ---
### Author: ![Zach\_Moffat](https://avatars.discourse-cdn.com/v4/letter/z/c37758/32.png) [@Zach\_Moffat](https://www.techhub.training/u/Zach_Moffat) #### Post date: [November 2, 2023, 4:07am UTC](https://www.techhub.training/t/34-alteryx-audit-attention/579/20 "2023-11-02T04:07:01Z")
[LedgerAlteryxPractice.yxmd](https://www.techhub.training/uploads/short-url/tg7IEoQhi76B0v6GUcBHt8WaOf5.yxmd) (14.8 KB) ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/8/8613a65496393f44a8f3f9f7d5cafba591cede0b.png) Here is my solution! This was a good challenge that had a good level of challenging, but also doable. [Next page](https://www.techhub.training/t/34-alteryx-audit-attention/579.md?page=2)