Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Im trying to calculate the average per month and just counting the current days in the actual month.
I have no problem calculated the output as long as I am selecting the current month.
The problem with my formula is that when I try to filter other months without selecting the current month, the output of my formula will be incorrent.
This is what im using:
Sum(SALES)/
(sum(TOTAL Aggr(COUNT(DISTINCT{ [YEARMONTH]), [YEARMONTH]))
-1+ (left(today([DATE]),2)/left(monthend(today([DATE])),2)))
Does anyone has any suggestions?
The reason of the aggregate function is that I don't want to take into account the months that didn't have a sale.
so if today is 23/07 I want the division to be the = sum count of the selected months + 23/30 -1 (The minus one being the actual month).