Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have a chart with values per day and asset code. And I'd like to have the variation from one day to the other for each asset code.
how can I do it?
Then try this:
Aggr(Sum({$<[ANO DO PREGAO] = {'2016'},[MES PREGAO]={'09'}>}(VALUE)/100)-Above(Sum({$<[ANO DO PREGAO] = {'2016'},[MES PREGAO]={'09'}>}(VALUE)/100)), ASSET_CODE, DAY)
Is this the goal?
Expression:
Aggr(Sum(VALUE)-Above(Sum(VALUE)), ASSET_CODE, DAY)
My origninal expression has some setanalysis, how can do as you did above in this case?
(SUM({$<[ANO DO PREGAO] = {'2016'},[MES PREGAO]={'09'}>}(VALUE)/100))
Then try this:
Aggr(Sum({$<[ANO DO PREGAO] = {'2016'},[MES PREGAO]={'09'}>}(VALUE)/100)-Above(Sum({$<[ANO DO PREGAO] = {'2016'},[MES PREGAO]={'09'}>}(VALUE)/100)), ASSET_CODE, DAY)
worked!
thanks