Hi everyone!
I am currently trying to create 2 variance calculations and 3 YTD calculation.
Lets start with the 2 variance calculations:
- The first variance should calculate the Total Sales of each day and reduce it with the Total Sales of a day in the prior year.
- The second variance should do the same, but in %
The YTD calculation should sum up Total Sales per day. Afterwards I want to create additional fields where I calculate two variances like above.
I have an issue with it, because our fiscal year starts at the first of May and ends at the end of April and secondly my variances should not just compare my figures with last year, we need to show variances based on weekdays this year vs. last year. I tried to illustrate it in the enclosed excel.
I tried to figure it out on my own by using other DOJO entries and DOMO University, but all suggestions led to errors or wrong calculations.
I would really appreciate help from you guys!
Many thanks
Nikolaus