Ignore filters for Networkdays calculation

Anonymous — Wed, 03 Jan 2018 18:23:35 GMT

I've looked around and seen several solutions for creating a static calculation on a field that is subject to filters, but my use case seems to be sufficiently different.

I am working on a daily report with a table that looks like this:

Employee	Days Since Last Phone Call	Days Worked
Gianna	5	4
Harold	2	5
Tyler	3	5

This report has a filter that allows users to select a number of weeks. The Days Worked column should be dynamic and show the number of days worked for the selected time period. However, I would like the Days Since Last Phone Call column to always show the number of days since the last call relative to today. Currently, it does so only when no filter is selected.

The code I am using for the Days Since Last Phone Call column is this:

Networkdays(Max(PhoneCallDate), Today() - 1)

I have seen several discussions that mention using set analysis, but I am not doing a count or sum so it does not appear to be applicable. I also cannot use TOTAL as I need the days to be per employee, not a whole.

Re: Ignore filters for Networkdays calculation

sunny_talwar — Wed, 03 Jan 2018 18:24:46 GMT

Try this

Networkdays(Max({1} PhoneCallDate), Today() - 1)

topic Re: Ignore filters for Networkdays calculation in App Development

Ignore filters for Networkdays calculation

Re: Ignore filters for Networkdays calculation