7 Replies Latest reply: Apr 28, 2016 5:04 AM by vivek sm RSS

    can you help me in set analysis

    vivek sm

      Hi ,

      I have problem in calculation logic.

       

       

      formula level1 %=(total available hours per month for level1 - sum(demo) / total available hours per month for level1

       

       

       

      formula level2 %=(total available hours per month for level2 - sum(demo) / total available hours per month for level2

       

      Note: Except Sundays only 6days in a week so I used a flag [Is Week End]<>1 for formula 2