Hi
I did this to calculate the average of money in the actual quarter
sum({<QUARTER=, YEAR=>}if(InQuarterToDate(DATE, today()-1,0), MONEY))
/
count({<QUARTER=, YEAR=>}distinct if(InQuarterToDate(DATE, today()-1,0), FECHA))
Now what i have to do is to calculate the average of money in "selected" quarter and year.
i have the field to select quarter and year, because of that i ignored them in that expression, but i dont know how to do the expression
I think the sum parte should be easy it's only sum(money) but i don't know how to do the count part of the days
Any Ideas?
Thank you
Greetings
