4 Replies Latest reply on Sep 15, 2014 1:27 PM by Matt Lutton

    Filtering with WINDOW_MAX, WINDOW_MIN, and WINDOW_SUM over a period of time.

    Rockford Wheeler
      •  

        I have a calculated field that is doing a calc based on WINDOW_MAX, WINDOW_MIN, and WINDOW_SUM over a period of time. The problem I'm having is that when I apply date filters, the calc field changes. So I can't give my users a date filter to see the current month, for example, because the values are based on the previous month. Am I missing something? It seems like this should be easier than it is.