
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Summing SET ANALYSIS with DISTINCT Variable
Hi,
I am working on writing an expression that pulls in the Total $ for the current year, based on episode number. However, since episode number is repetitive on multiple claim lines, I would want the expression to be distinct on the episode number.
CY TOTAL PAID $:
=SUM({$<[Report Year] = {'Current Year'}>} TOTAL_ALLOWED)
CY TOTAL EPISODES:
=COUNT({$<[Report Year] = {'Current Year'}>} DISTINCTepisode_num)
I have the expressions laid out, but realized the CY TOTAL PAID value in the first expression is not distinct based on episode number, so the $ is tripling its value. How would I make the SUM of the SET ANALYSIS in CY TOTAL PAID to be SUMMING based on DISTINCT episode number only?
Please advise.
Thank you,
Clem☺
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
may be below
=sum(aggr(SUM({$<[Report Year] = {'Current Year'}>} TOTAL_ALLOWED),episode_num))
or
=sum( distinct aggr(SUM({$<[Report Year] = {'Current Year'}>} TOTAL_ALLOWED),episode_num))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
may be below
=sum(aggr(SUM({$<[Report Year] = {'Current Year'}>} TOTAL_ALLOWED),episode_num))
or
=sum( distinct aggr(SUM({$<[Report Year] = {'Current Year'}>} TOTAL_ALLOWED),episode_num))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you so much, Kush!! ☺
It was the first expression that lined up!
=sum(aggr(SUM({$<[Report Year] = {'Current Year'}>} TOTAL_ALLOWED),episode_num))
Much appreciation,
Clem

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Glad that helpful
