2 Replies Latest reply on Aug 4, 2017 10:04 AM by Jim Dehner

    Table Calc on a Table Calc

    Brian Purcell

      Hi,

       

      I'm trying to perform a table calc on a field that is a table calc.  I have our industry and company units for a specific period.  I've used a percent of table calc

       

      ZN(SUM([Units])) / LOOKUP(ZN(SUM([Units])), -1)

       

      The problem is I need to run another calc that would display YOY change.  I can create a sample data set if this would help.  Thanks.

        • 1. Re: Table Calc on a Table Calc
          Shinichiro Murakami

          Hi Brain,

           

          Table calc is really table dependent and it's impossible to provide answer without actual data.

          Please attach packaged workbook with sample data.

           

           

          Thanks,

          Shin

          • 2. Re: Table Calc on a Table Calc
            Jim Dehner

            Hi Brian

             

            Yes you can - not exactly sure it you just wanted a net diff or a % on the % but see the attached

            the difference is           LOOKUP(([change %]),0) - LOOKUP(([change %]),-1)    from the change percent

            making that a % is      (LOOKUP(([change %]),0) - LOOKUP(([change %]),-1))/LOOKUP(([change %]),0)

             

            Let me know if that helped

             

             

            Jim

            If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.