select just 1 month from 1 field

[davinfrost]

hi guys, i have a case,
when i filter date, i choose month , on november.
as we can see on the table, all data showed based on paymentdate.

Branch	InvoiceNo	InvoiceDate	PaymentDate	KEY_DATE	FLAG_TRANS	TERMSID	COD_GROUP	COD_INVOICE
CAA	CISI 18 1918 CAA	10/30/2018	11/8/2018	20181108	Duedate_Inv	1	>7 DAYS	9
CAA	CISI 18 1923 CAA	11/1/2018	11/2/2018	20181102	Duedate_Inv	1	1 DAYS	1
CAA	CISI 18 1927 CAA	11/1/2018	11/16/2018	20181116	Duedate_Inv	1	>7 DAYS	15
CAA	CISI 18 1954 CAA	11/9/2018	11/19/2018	20181119	Duedate_Inv	1	>7 DAYS	10

i use this :

count(aggr(sum(
{<
TERMSID={'1'},
FLAG_TRANS={'Duedate_Pelunasan_Inv'},
COD_GROUP={'>7 DAYS'},

Day={">=$(=Num(Min(Day)))<=$(=Max(Day))"},
// Month={'$(=max(Month))'},
Year={'$(=max(Year))'}
>} 
COD_INVOICE),[Invoice No]))

how to change based into invoicedate, so if i choose november, only invoicedate on november are show? because its still appear 1 data from october? did i miss something?

thank you.

[Anil_Babu_Samineni]

May be ignore the field

count(aggr(sum(
{<
TERMSID={'1'},
FLAG_TRANS={'Duedate_Pelunasan_Inv'},
COD_GROUP={'>7 DAYS'},

Day={">=$(=Num(Min(Day)))<=$(=Max(Day))"},
// Month={'$(=max(Month))'},
Year={'$(=max(Year))'}, invoicedate=
>} 
COD_INVOICE),[Invoice No]))

[Zhandos_Shotan]

Hi!

May be like this:

Max( 
Aggr( 
Count({<InvoiceNo={"=Month(InvoiceDate)=Month(PaymentDate)"}>} InvoiceNo), 
InvoiceNo)
)

Check attached sample

Best regards