Expression error

[bluesky]

=sum(Aggr(Count({<member_id -={'Non Family'},date=p([date_ly])>} DISTINCT member_id ),date_ly))

member_id , date , date_ly are fields. Can anyone please say if this expression has syntax error ? What could be the possible  problem?

[Chanty4u]

can you try this?

sum({$<member_id=>} aggr(count({$<member_id -={'Non Family'},date=p([date_ly])>} DISTINCT member_id ,date_ly)

[QFabian]

hi, try using " instead '

[bluesky]

it is not working @Chanty4u . The idea

a) being aggregate by members by date and then sum it up as say x.

b) find the x for date_ly by using date column.

b is tough as we are using the date column to find this year member count and last year member count. note last year member count is not 365 days shift by done by finding what is the exact last year date in another column date_ly