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