Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have the expression =Count({$<Type={'Weekly Contact'}>}[MeetingSubID]). How can I tweak this so that it counts on distinct MeetingSubID (This field has duplicates).
Thank you
H
=Count({$<Type={'Weekly Contact'}>} DISTINCT [MeetingSubID])
=Count({$<Type={'Weekly Contact'}>} DISTINCT [MeetingSubID])
Try like
=Count( DISTINCT {$<Type={'Weekly Contact'}>} [MeetingSubID])
Perfect, thank you