Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
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)
Thanks,
I thought I was close!