List Box with set analysis and AGGR

[laureadiaz]

Hello,

   I am trying to make a list box that finds every item/ID, that has been flagged with a Y for 1 field on a quote, but I want to find them for all entries not just the dates selected.

I think this is close but not quite there (getting no entries in the list box):

AGGR(IF(ONLY({$<year={"$(>='2019')"}, date_entry= , month= , week= , Period= , WPeriod= , PeriodID= >}
SD$ROIYN)='Y',
,Short_ID, null())
,quote_number, ordered_part_number, Short_ID)

This works but only for selected time frame:

IF(AGGR(SD$ROIYN, quote_number, ordered_part_number, Short_ID)='Y',
Short_ID, null())

Any ideas?

[Anil_Babu_Samineni · Accepted solution]

I don't know below one issue. But syntax should be

AGGR(IF(ONLY({$<year={">=2019"}, date_entry= , month= , week= , Period= , WPeriod= ,PeriodID= >}
SD$ROIYN)='Y', ,Short_ID, null()),quote_number, ordered_part_number, Short_ID)

[laureadiaz]

Thanks,

    I thought I was close!