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

    Getting the Previous data

    KHARANSU RATH

      Hi,

      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.