aggr and set analysis

[#1]

Hi im trying to get the same result as this formula when i select excluded SiteID=9999

sum(AGGR(Count(DISTINCT SiteID),TransportAssignmentID))

i tried this but it wouldnt help

sum({$<SiteID =-{9999}>}AGGR(Count(DISTINCT SiteID),TransportAssignmentID))

[marcus_sommer]

Try:

sum(AGGR(Count({$<SiteID -= {9999}>} DISTINCT SiteID),TransportAssignmentID))

- Marcus

[sunny_talwar · Accepted solution]

Try this may be:

Sum({<SiteID =-{9999}>}Aggr(Count(DISTINCT {<SiteID =-{9999}>} SiteID),TransportAssignmentID))