Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You should apply ABOVE-formula without aggregation (aggregation is already defined by the week).
See the attached.
HTH
Peter
You should apply ABOVE-formula without aggregation (aggregation is already defined by the week).
See the attached.
HTH
Peter
I can just second the reply/answer from Peter. You should use the Above function to claculate the difference between the weeks.