This content has been marked as final. Show 2 replies
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 ?
|Week||Aggegate AUM||% Change AUM|