Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When i use NUM(Date(WEEKEND(LOAD_DATE),'MM/D/YYYY')) I am getting value with decimal i.e 42708.999999988
But when i pass the value of Date(WEEKEND(LOAD_DATE),'MM/D/YYYY') directly i.e 12/4/2016 by hardcoding
NUM('12/4/2016') i get whole number 42708.
Could you please let me know how can i avoid decimal with first expression, because of this bug i am getting one value extra for all the count.
Try
NUM(Date(WEEKEND(Floor(LOAD_DATE)),'MM/D/YYYY'))
You can simply write
Floor(LOAD_DATE)
also
Or may be Number format define
NUM(Date(WEEKEND(LOAD_DATE),'MM/D/YYYY'),'##0')
I think manish weekend gives a timestamp instead of date, so having the Floor after Weekend should fix the issue
Num(Floor(WeekEnd(LOAD_DATE)))