2 Replies Latest reply: Nov 27, 2009 1:48 PM by Fredrik Ehnö RSS

    Weekley aggregations

    jking1975

      Hello

       

      I have a table which has a daily date and a numeric field called [assets] , using the load script I have defined date parameters using week , month , Year

      I am attempting to aggregate [assets] by week within a chart which is fine but I alos want to show the change in aggregate [assets] . I have attempted to do this by using (current aggregate [assets] - before aggregate [assets]) but get nil returns .

       

      Any ideas ?

       

       

      parentco_friendname Lyxor
      Week Aggegate AUM% Change AUM
      47€13647
      46€11499
      45€14402


       

      Thanks James