1 Reply Latest reply: Jun 27, 2014 3:16 AM by Gysbert Wassenaar RSS

    FORMULA IN LAYOUT

      I HAVE A COUNT 3 CALCULATES FORMULAS THAT WORKS FINE.

       

      I CALCULATE NEW SUPPLIER, LOSSER SUPPLIER, AND PORTFOLIO.

       

      NOW I WONT TO NOW THE CHURN OVER THE YEAR.

       

       

      BASICALY IS IT.

       

      PORTFOLIO IN FIRST WEEK OF THE YEAR / ACCUMULATE LOSSER IN THE YEAR TO ACTUAL WEEK.

       

      My problem is for the year before. how can i do it in the pass. right now I put the first week of the year in a variable.

       

      and y count the portfolio in first week of year /

      /

      count with set anayliss week >= firstweekof year (variable) and <= actual week (variable) losser supplyer.

       

      Thanks in advance