3 Replies Latest reply on Aug 3, 2016 6:42 PM by Tom W

How to count no of day which only have data or not null

darin petchnon Jul 30, 2016 8:23 PM

Hi, my name is Ann

I have sum of Revenue data and I would like to find Revenue per Day. So I need to count no of day that only have revenue. How to count it?

Thank you,

1. Re: How to count no of day which only have data or not null

Tom W Jul 31, 2016 9:22 AM (in response to darin petchnon)

COUNT(IF zn([Revenue]) > 0 THEN [Order Date] END)
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
2. Re: How to count no of day which only have data or not null

darin petchnon Aug 2, 2016 11:15 PM (in response to Tom W)

Dear TOM,

I follow your suggested, I's work. I can apply to my task & Thank you for your quick response !!

Ann
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
3. Re: How to count no of day which only have data or not null

Tom W Aug 3, 2016 6:42 PM (in response to darin petchnon)

Hi Darin,
Glad I could help out. Please mark the answer as correct (not just 'helpful') to close out the thread.

Thanks!
Like Show 0 Likes(0)

Actions

Tableau Community Forums