3 Replies Latest reply: Jun 19, 2017 8:43 AM by Andy Weir RSS

    Report constantly updating when no update has happened

    Andy Weir

      I have a weird one that maybe you guys can shed some light on.

       

      I have an up to date cached report.

       

      When i go into preview it I get a dataentity error message like the report isnt up to date.

      I click to update the objects in this case a straight table and run the preview this time it generates and the same 4 fields keep not displaying.

       

      <=[Activity ID]>

      <=AGGR(DISTINCT [%ClaimKey],[%ActivityKey])>

      <=AGGR(MAX(DATE([Claim Submitted Date],'DD/MM/YYYY')),[%ActivityKey])>

      <=IF([_ApprovedFlag]='True',[Activity Status],null())>

       

      The rest of the fields generate fine its these same fields each time.

       

      In case you think its the <= part I have plenty of fields that have start and it works fine

       

      <=Date([Activity Start Date],'DD/MM/YYYY')>

       

      Any suggestions?

       

      Regards

       

       

      Andy