2 Replies Latest reply: May 7, 2014 9:54 PM by jagan mohan rao appala RSS

    retrieve on a certain date?

    ben lim

      Hi I have a table that has the dimension Month_Year and Expression with a formula.

       

      The formula is an expression that (a+b) / c

       

      a and c data is updated daily on our system and b is updated every monday.

       

      Is there any codes that I can do to ensure that the current month (not the historical months) will only compute based on every monday?

       

      saying that today is wednesday, the figure is still on latest monday instead of today as it will dilute the % away.