none
Weekly Slippage delta RRS feed

  • Question

  • Hi,

    I generate a weekly slippage from various MSP plans. using the below formula

    IIf(([Finish]-[Baseline1 Finish])>=1,([Finish]-[Baseline1 Finish]),0)"Finish" being current finish date, and "Baseline1Finish" is last week's finish date

    The formula returns nos of days (Incl non-working days).

    How can I tweak the above formula to exclude non-working days

    Thanks

    Thursday, July 14, 2016 10:29 AM

Answers

  • When you write the formula have a look at the other functions such as projdatediff() which allow you to specify a calendar.
    • Marked as answer by Immanoye Thursday, July 14, 2016 12:13 PM
    Thursday, July 14, 2016 11:13 AM
  • This is the function and the arguments for the function:

    ProjDateDiff( date1, date2, calendar )

    In your formula, you have not specified the name of a calendar.

    • Marked as answer by Immanoye Thursday, July 14, 2016 3:11 PM
    Thursday, July 14, 2016 2:07 PM

All replies

  • When you write the formula have a look at the other functions such as projdatediff() which allow you to specify a calendar.
    • Marked as answer by Immanoye Thursday, July 14, 2016 12:13 PM
    Thursday, July 14, 2016 11:13 AM
  • I have substituted the "IIf(([Finish]-[Baseline1 Finish])>=1" with  IIf(ProjDateDiff([Finish],[Baseline1 Finish])>=1

    Still I don't get the value .. The syntax might be wrong?

    Thanks

    Thursday, July 14, 2016 1:34 PM
  • This is the function and the arguments for the function:

    ProjDateDiff( date1, date2, calendar )

    In your formula, you have not specified the name of a calendar.

    • Marked as answer by Immanoye Thursday, July 14, 2016 3:11 PM
    Thursday, July 14, 2016 2:07 PM
  • Thanks very much .

    I will apply that

    Thursday, July 14, 2016 3:12 PM