Discussion board where members can get started with Qlik Sense.
Having NetworkDays with same Start Date and End Date gives Value as 1 i want it as 0,
Tried using if(start date=end date,0,networkdays(Startdate,enddate)) Still Giving output as 1...y is it so??
Go to Solution.
Does your start date and end date also have time stamps?
try this instead
= if(FLOOR(NUM(start date))=FLOOR(NUM(end date)),0,networkdays(Startdate,enddate))
Hello Vineeth ,
Thankyou it worked .
Happy to help