Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi guys,
i want to ask , how to sum a specific date on every month ,
in this case i want sum every last date on every month,
for example, if i filtered january,february and march, that means it will sum on 01/31 , 02/28, 03/31.
for now i only use this condition
sum(
{<
FLAG_TRANS={'Outstanding'},
Year={'$(=max(Year))'}
>}
OOWING)
any help?
thanks
sum(
{<
Date={"=If(Date=Text(Date(MonthEnd(Date))), Date)"},
Year={'$(=max(Year))'}
>}
OOWING)
=if(getselectedcount(month)>0,sum({<year={"$(=max(year))"},date={"$(=monthend(date))"}>}OOWING),sum({<year={"$(=max(year))"}>}OOWING))
sum(
{<
Date={"=If(Date=Text(Date(MonthEnd(Date))), Date)"},
Year={'$(=max(Year))'}
>}
OOWING)