1 Reply Latest reply on Oct 3, 2016 9:32 PM by Mahfooj Khan

    Fixed LOD expression is changing with filter

    Chrissy Scott

      Hi All,


      I have a view where I show the number of total incident tickets for a quarter and the number of incident tickets per Core Service. I want the total number to remain unchanged when I filter the view by Core Service. So I have an LOD expression that goes like this:


      Trouble is... my FY16Q4 Qtr total value is still changing when I filter by Core Service:



      I'm using an ODBC connection to ServiceNow and am appending historical data from a different system. The core service names did change in this quarter. But the Core Service filter does work correctly when it's used elsewhere.