The title makes this seem simple. I’m having trouble coming up with with a sum for prior year.
To arrive at the current year I had to patch a couple of fact tables together as the figures begin in the year 2000. The correct answer is a cumulative total of all the amounts since 2000.
I have one grouped by fact table from 2000-2017 and then a detailed level table for 2018 to current which is used in a number of other areas.
I have attached the steps I have taken to arrive at the correct figure for 2020 but getting to same period last year is where I do appreciate some help.
I’m not permitted to share the file do to a confidentiality agreement.
Thank you very much! Happy July 4th to those who celebrate
…Accounts Receivable Question.pptx (58.4 KB)