3 Replies Latest reply on Jan 18, 2019 10:36 PM by Hari Ankem

    LOD Expressions cannot contain table calculation or the ATTR function


      Why I am getting this error when I run this query? I am trying to include the date in the LOD by using {INCLUDE} function and I got the error below:


      { INCLUDE [Trans Date]: [Current Penetration]}



      Current Penetration:

      IF ATTR(DATEPART('year',[Week Ending])=DATEPART('year',[Trans Date])) THEN [Fixed Penetration] END



      I want to remove the date in the column and just get the value of current penetration but when I remove it, there is no value/output for the LOD


      No result: