3 Replies Latest reply on Oct 25, 2018 2:48 AM by kumar.c

    Getting the Previous data



      I want to get the absolute percentage difference on the count of inventory number for 5 locations and the differences will be based on present week count and previous week count.

      I am using the below written code:


      {FIXED [Unit Name (group)]: COUNT([Inv. Number])-LOOKUP(COUNT([Inv. Number]),-1)}

      //-LOOKUP(COUNT([Inv. Number]),-1)/LOOKUP(COUNT([Inv. Number]),-1)


      but I am getting this error:


      level of detail calculation cannot contain table calculations or the ATTR functions


      How can I solve it?


      Thank You.