Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The expected day is calculated as: networkdays(startdate,duedate) and actual days as: networkdays(startdate,finalcompdate)
but for same start day and finalcompdate i want the expected and actual days as 1. but for first few values i am getting 0
PFA
I think you need to adjust the result manually maybe just with + 1 if you want to display a different logic. Further it looked that you don't use dates instead of timestamps and you may change this, too - for example with: date(floor(YourTimestamp)).
- Marcus