Weekley aggregations

[#1]

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

[prieper · Accepted solution]

You should apply ABOVE-formula without aggregation (aggregation is already defined by the week).
See the attached.

HTH
Peter

[#3]

I can just second the reply/answer from Peter. You should use the Above function to claculate the difference between the weeks.