3 Replies Latest reply: May 25, 2017 5:44 PM by Justin Taylor RSS

    create a blank record

    Justin Taylor

      Our Master Calendar projects dates into the next month.

      We have a MonthSequence field that numbers each month. 
      ...

      April 2017 is 140

      May 2017  is 141

      June 2017 is 142.

      I need to create a MonthSequence field that ignores next month (June 2017 or 142)  and either puts a null value in there or something less than our beginning MonthSequence number of 77

       

      I tried this (and multiple iterations of it) but I keep getting an expression error:

       

      If((Max(MonthSequence) - (MonthSequence))=0,'', MonthSequence) as TrueMonSeq

       

      Any thoughts on the middle of that if statement... or another way to do this?

      thanks