Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using below expression to calculate the accumulated returns with date and symbols as dimensions for a line chart. This works fine if I select a one symbol.
(rangesum(above(total sum(returns),0,RowNo(TOTAL))))
But I want to be able to select multiple symbols at the same time, plot accumulated returns for each symbol in the line chart.
I know I can simple plot the returns in the line chart by checking full accumulation, But I want to do that in an expression.
Could any one please help me with my problem??
Dummy data would be useful to play around with. Otherwise I can only speculate the idea of using a aggregate function. May or may not work.
Best,
S
Hi
I have noticed similar issues. Simply put, it looks as if the accumulation only occurs at the lowest level of dimension. But I haven't yet found that explained anywhere.