YTD concept confusion. YTD for all months in a given year or just up to the current period chosen
Hi Elista!
I'm a bit confused here. Our current period was Aug-20, but what I see is that YTD appears in rows that are in year 2020 BUT exceed the month of August. Isn't that contrary to what is meant by YTD? Isn't the YTD supposed to show all products in the raw data that are in year 2020 BUT do NOT exceed the month of August. Why does it consider all the months in year 2020 knowing that our current period chosen was Aug-20 and NOT Dec-20 for instance?? Shouldn't we add an AND to our IF statement where it not only checks if the row was in the same year of our current period, but also check if the MONTH of that row is not greater than the month of our chosen current period?
Hi Anas,
can you be more specific as to which values exceed the current month in YTD, if you could send me a screenshot of your Excel sheet that you'd be best. Thanks in advance!
Best,
365 Eli
Starting from row 1811 shown in the screenshot, you can see that the YTD values are shown. To be honest this is not surprising to me because following your if condition statement defined in the course for YTD, it would result in this. The reason is because your did not add another condition that restricts the month exceeding problem. You just defined an IF condition that checks whether the YEAR of the current period chosen by the user is in line with the year of the data rows.
Hi Anas,
I believe you are correct because you would get future months based on
only checking the year, and you had a month less than 12 but had transactions greater
than the selected month. I used this formula: =IF(AND(D4=YEAR(C4),INT(A4)<=MONTH(dashboard!$B$5)),"YTD",""),
assuming that the month selected on the dashboard has completed. If the month selection
still needs to be completed, then you would need to do additional logic. But
given that we do not have a timestamp of the transaction in the raw data, we do
not have a date to compare.
Regards,
Michael