What the example shows
217 unscheduled items. 185 accrued day by day over the access period, 32 excluded with a reason. Second workflow: the look-back a month later, accrual against what RAR scheduled.
What you get
- The ebook: an 89-page PDF that walks through the workflow tool by tool
- 2 tested Alteryx workflows (31_Unscheduled_Accruals.yxmd, 31b_Accrual_Lookback.yxmd)
- Synthetic sample data (9 files) and an answer key, so you can check every number
- Runs in Alteryx Designer 2023.1 or later; one zip, delivered by email right after payment
Contents
- Chapter 1Revenue that is waiting for an event
- Chapter 2The seven files
- Chapter 3Cleaning and dating the report
- Chapter 4Six lookups that cannot lose a row
- Chapter 5One reason per row, and the accrual
- Chapter 6The lookup gaps and the population control
- Chapter 7Reading the result
- Chapter 8Moving it to your system
- Chapter 9A month later: the look-back
- Chapter 10Exercises
- Appendix ATool-by-tool settings
- Appendix BOutput field dictionary
- Appendix CAnswer key
Look inside


