0 Replies Latest reply: May 23, 2013 12:57 PM by sonia dominiak RSS

    Syntax - Time Period

      I have a report containing three columns: Posting Date, Amount, and Category. Each category consists of B, O, and C. I added a column to sum up categories B + O. and another column to sum up category C. I would like to add a filter to column (sum B+O) so that column stops adding after 06/15/2013. Basically this column will refresh between 05/01/2013 and 06/15/2013 but not beyond that date. How can I do that? I want all other columns in the report to keep refreshing beyond 06/15/2013. My expression for that specific column is:

       

       

      sum

      (if(Category = 'B' or Category = 'O', Amount)/FXMay2013)

       

      The posting date format is DD/MM/YYYY