Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
date | tickets |
---|---|
05/01/2015 | 10 |
05/23/2015 | 20 |
Hi Gurus,
Excluding Sat ,sun days i want to count no of tickets created in selected Period
Thanks
Something like:
=Sum(if(Not Match(Weekday(date),'Sat','Sun'),tickets))
Hi Babu
Use Networkdays dunction as mentioned below
Networkdays (start:date, end_date {, holiday})
Regards
Kaushal
Hello!
count(if(num(WeekDay(date))<>5 and num(WeekDay(date))<>6, tickets))
Hi tresesco,
thanks for your time,its working fine .
but i forgot to include another condition
i want to calculate last 30 days sum ,today-30 excluding (Sat,Sun)
thanks,
Hi Are Babu, also you can do:
=count(if(WeekDay(Date)<>'sun' and WeekDay(Date)<>'sat', Tickets))
I attach the solution where I do the answer of you question.
Best regards,
Agustìn !
hi thnks for your time ,
your counting holidays but i need to exclude holidays and show last 30 days data (Excluding sat,Sun)
Thanks,
Babu
a little change to tresesco answer
=Sum({$ <date={"<=$(=Today())>=$(=date(Today()-30))"}>} if(Not Match(Weekday(date),'sat','sun'),tickets))
Hi massimo Grossi,
Its working fine but today ()-4 its doing sum only 3 values(excluding Sat,Sun).
I want to sum last 4 values excluding sat,sun
how to achieve this
PFA
Thanks,
Babu
maybe you can try with
add a date serial field to your table 1, 2, 3, 4, etc.... but skip (set -100) the sat sun
n fri
-100 sat
-100 sun
n+1 mon
....
and replace in set analysis
=Sum({$ <dateserial={"<=$(=max(dateserial))>=$(=max(dateserial)-30)>"}>} tickets)