Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
I have a requirement where we need to calculate the no of days between start date and end data.
We can use the
but this function automatically excludes saturday and sunday.
What i need is to exclude Thurday and Friday as non working days and include the saturday and sunday as working day while doing the calculation.
Our client working days are Sat-Wed and Thu-Fri as weekOff.
So how can i use an logic to calculate the exact no of days.
Please advise how to achieve it.
Your suggestion is much appreciate.
Regards
Best way is take a primary key field from your data model tables..
And write the expression like
if(count(primarykey)>0 ,count(distinct date))
then it will display the working days of your customer data regardless sun,wed...etc