2 Replies Latest reply: May 17, 2017 9:54 PM by buck master RSS

    Networkdays not responding - Sense V3.2.3

    buck master

      Date formats look like this:

           07/01/2016, 07/05/2016

           07/03/2016, 07/14/2016

           .....

      SET DateFormat='MM/DD/YYYY';

       

      The load script is as follows:

       

      LOAD *,

        If(IsNull(ValueNullConv),  0, NetWorkDays('Post Date', 'CH Signoff Date')) as  [CH DAYS AGED];      //all i see is a zero?

      LOAD

        [Post Date],

        [Signoff Date],

        If(len(trim([Signoff Date]))= 0 or [Signoff Date]='NULL' or [Signoff Date]='-', Null(), [Signoff Date] ) as ValueNullConv

       

      FROM [lib://XXXXX/YYYYYYY.xls]

      (biff, embedded labels, table is AAAATransactions$)

      Where [Amount] <> 0;

       

      While testing, i dropped a KPI Object on the page that has an expression like:      NetWorkDays('Post Date','Signoff Date')

      nothing shows?

       

       

      Any help is appreciated

      Thanks