0 Replies Latest reply on Aug 10, 2018 8:40 AM by Roger Palmen

    For future dates, analysis preview gives Calc Failed, while Time Series data shows OK

    Roger Palmen

      I have an AdHoc analysis that uses a combination of time-series table lookups, and Historical values to determine a forecast. Let's say we use variable A that is the historical value (PI Point), and variable B that is the table lookup providing the Future values,a nd i just do A+B. As requesting the value of a historical value at a future date fails, i use: PrevVal('attribute', '*') to get the value of A. Now the behaviour:

      • Evaluate runs fine, all data is correct.
      • Preview for * to *+5d however, only runs correctly for *, all subsequent dates give a calc failed on A
      • Time Series Data also returns the correct data for * to *+5d

       

      Why is the preview failing here?