8 Replies Latest reply on Jun 18, 2018 12:02 PM by Deepak Rai

    Projecting % based on target

    Harjeet kaur

      In my data i have a calculated field that % of member were seen as of today for every ID  and i have another calculated field which gives how many members they need to see per week for the next 16 week to meet the target 94%.

       

      What I am looking for is another calculated field where i can see what an IDs % seen rate is  based on an ID's current %seen rate and their target per week for next 16 weeks

       

      Ex: id : 0079067 has 61% seen rate as of today and their target per week is 10 members what would their projected % seen be next week if they met the target per week