Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a list of dates and these should be summarized and grouped by another fields in AGGR.
I tested in a listbox with showing only the dates by using =NOT MATCH(NUM(WEEKDAY(Full_Date)),0,6) and I receive all days except Sun and Sat as expected.
How to get these values inside the AGGR?
I tried something like that:
=IF(NOT MATCH(NUM(WEEKDAY(Full_Date)),0,6), SUM(AGGR(AVG(Value_1), Full_Date, Value_2)))
but it does not work.
How is correct to use only days from Mon to Fri in the AGGR?
Full_Date is selected by the user and can vary between 1 day to months and years.
Best Regard,
Drago
How about this
Sum(Aggr(
Avg({<Full_Date = {"=Match(WeekDay(Full_Date), 0, 6) = 0"}>} Value_1)
, Full_Date, Value_2))
or
Sum(Aggr( Avg({<Full_Date = {"=NOT Match(WeekDay(Full_Date), 0, 6)"}>} Value_1) , Full_Date, Value_2))
SUM(AGGR(AVG({<Full_Date={"=$(=match(num(weekday(Full_Date)),0,6))<1"}>}Value_1), Full_Date, Value_2)))
wat about
SUM(total AGGR(AVG({<Full_Date={"=$(=match(num(weekday(Full_Date)),0,6))<1"}>}Value_1), Full_Date, Value_2)))
How about this
Sum(Aggr(
Avg({<Full_Date = {"=Match(WeekDay(Full_Date), 0, 6) = 0"}>} Value_1)
, Full_Date, Value_2))
or
Sum(Aggr( Avg({<Full_Date = {"=NOT Match(WeekDay(Full_Date), 0, 6)"}>} Value_1) , Full_Date, Value_2))
@d_petrov I think i missed your comment. Please try as sunny suggested.
Thank you,
I just added the NUM() in the expression , because we need it as a number and it worked like that:
SUM(AGGR(AVG({<Full_Date = {"=MATCH(NUM(WEEKDAY(Full_Date)), 0, 6) = 0"}>} Value_1), Full_Date, Value_2))
Thanks and regards,
Drago