
Creator
2022-02-22
10:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to exclude date based on aggr function
=avg(aggr((RUN_DATE_TIME-RECEIVED_DATE_TIME)*24,ACC_ID))
I am trying to use set analysis in this function to exclude all ACC_IDs that have a run_date_time>= Received_date_time
{<[RUN_DATE_TIME]={'=[RUN_DATE_TIME]>=[RECEIVED_DATE_TIME]'}>}
I have tried using this before the aggr and after the aggr but it does not work as intended.
549 Views
1 Reply

.png)
Former Employee
2022-02-22
11:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You need double quotes for searches.
Avg({<ACC_ID-={"=[RUN_DATE_TIME]>=[RECEIVED_DATE_TIME]"}>} aggr((RUN_DATE_TIME-RECEIVED_DATE_TIME)*24,ACC_ID))
523 Views
