less than or equal set analysis

[delbooth]

Hi.

I have two fields in the same table called orders.  The two fields I want to evaluate by record are Date_collected and planned_to_date.

I want the set analysis to only include records that are Date_collected<=Planned_to_date

ie

count({<ColYear={"$(=year(Today()))"},Units={"t"},Date_collected<=Planned_to_date>}[Collection Code])

Thanks

[agigliotti · Accepted solution]

maybe this:
count( {< ColYear = {"$(=year(Today()))"}, Units = {"t"} >}
if( Date_collected <= Planned_to_date, [Collection Code] ) )
I hope it helps.