Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI i am doing current VS previous year calculation.
Variable -
vDay =Sum(Aggr(Sum(Distinct Month_Day),Month))
when i select 2018 and 2019 the vDays will give me 365 days which is correct
but when i select 2019 and 2020 or 2016 and 2017 it gives me 394 days
Note when i select 2020 only it gives me 366 which is correct , it seems the leap is not working when i select leap year vs regular year
Here are some prior posts on Leap Year problems that may help:
No idea if these are going to help or not, but seem to be a couple of key points on things. My post will kick this back up in the list again, so someone else may chime in too, but folks may need a QVW as well with this one to see the data model etc. too.
Regards,
Brett