4 Replies Latest reply on Jun 9, 2016 4:45 AM by Hannah Williams

    Calc to create a temporary NULL field

    Hannah Williams

      Hi,

       

      I want create a calc which creates a temporary NULL field, so that my initial data extract of a table is very quick, but the following incremental refresh would then pull in all the data.

       

      My idea is to use the max date value from the timestamp field, which as of tomorrow will no longer be the max.

       

      IF  [Time Stamp] MAX(25/05/2016) then [Statistic Data Id]

      ELSEIF NULL

      end

       

       

      Any ideas on the correct calc for this?

       

      Thanks

       

      Hannah