4 Replies Latest reply: Sep 17, 2018 5:11 PM by Dilip Ranjith RSS

    How do I make a table that automatically shows the previous day's values or a specific day's values?

    Jesse Correa

      I'm trying to create daily snapshots of the values of various projects, as they change daily. Currently, the database I work with only stores monthly snapshots. I need the ability to see the amount that the values change from day to day.

       

      I currently use a table with a row for each project and a column with their values for each month as well as their current values. There are too many projects to manually copy the values from the current day into a new column to compare them to the next day's values.

       

      How do I make a column in the table that automatically shows the previous day's values? Is there a way to pull the project values for a specific day without having daily snapshots stored in the database?

       

      This is the current script for the project value (LE):

      Sum(

           {<

           [Snapshot Type]={'LE'},

           Baseline=,

           Baseline_LE=,

           //AAKT-2772

           //[Direct Indirect Flag]={$(=$(vDirectIndirect))},

           [Default Type] = {$(=$(vCFType))},

           //--

           [Report Currency]={'$(=$(vSelectedCurrency))'},

           [SC Finance Filter]={1},

           [SC/Non-SC]={"$(=$(vSCNonSC))"}

           >}

           [Finance Amount]*$(vCurrencyConversionKPI)

      )