8 Replies Latest reply: Jan 31, 2017 9:00 PM by Lokesh Patel RSS

    Date Variable in Set Analysis

    Lokesh Patel

      Hi Team,

       

      I have a variable vR3Date which contains a date in DD-MM-YYYY format.

       

      This variable value is set during the load script.

       

      how can can I use this variable in following expression to only show sum where SalesDate is >= the variable date?

       

      =SUM(SoldUnits)

       

      Thanks you