3 Replies Latest reply: Feb 14, 2017 5:48 AM by Rahul Pawar RSS

    Network days concept in schedule variance

    sahil thakur

      Hi Everyone,

      This is my schedule variance code, i want to apply network days concept in the above code so that it will not include Saturdays and Sundays.

      num(

        (sum(

        {<prd_id-= {'Daily'}>}(mlt_act_prj_end_dt-mlt_act_prj_st_dt)

          )

        -Sum(

        {<prd_id-= {'Daily'}>}(mlt_pln_prj_end_dt-mlt_pln_prj_st_dt)

        )

        )

        /sum(

        {<prd_id-= {'Daily'}>}(mlt_pln_prj_end_dt-mlt_pln_prj_st_dt)

          )

        

      ,'###%'

        ),

       

      Please let me know how i can apply that logic in the above code.

       

      Thanx