2 Replies Latest reply: Mar 30, 2016 4:57 AM by Kirsten Zawierucha RSS

    Flag for an entire month when a day is already flagged

    Kirsten Zawierucha

      Dear community,


      I have the following problem:

      Some days do not have sales. I already flagged these days in my script.


      if(IsNull(Sales),1,0) as DayFlag,
      RESIDENT Temp;


      Now, I also need to flag the entire month when there is a day without sales (respectively there is a flagged day in that month).


      Are there any suggestions how to solve my problem?


      Thanks in advance,