topic Re: Networkdays not responding - Sense V3.2.3 in App Development

Networkdays not responding - Sense V3.2.3

deerhunter — Mon, 15 May 2017 22:45:30 GMT

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

swuehl — Mon, 15 May 2017 22:53:09 GMT

What is 'CH Signoff Date' you are using in Networkdays() function?

deerhunter — Thu, 18 May 2017 01:54:34 GMT

i finally got it working:

If(IsNull(CHSignOffNullConv), NetWorkDays([Post Date], $(vPullDate)), NetWorkDays([Post Date], [CH Signoff Date])) as [CH DAYS AGED],

Thanks