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

    LOD Expressions cannot contain table calculation or the ATTR function

    evelyn.monares

      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: