
Re: Help in accumulation formulas (Replacing above)
Marc Livingston Aug 29, 2012 2:47 PM (in response to Cesar Accardi)Try using Monthname Functions with AddMonths(Date,12) You could use this in SET to avoid using above

Re: Help in accumulation formulas (Replacing above)
Cesar Accardi Aug 29, 2012 2:59 PM (in response to Marc Livingston)Hi,
thanks for the quick response... Like this?
sum({$<[Descrição do Subindicador]={'CUBPR'},Ano={"$(=Year(AddMonths(Date#([Ano Mês],'YYYY/MMM'),12)))"}>} Valor)
If put the modifier expression in a new the result appears to be correct (last year), however the expression "12 Meses" doesn't show any value:


Re: Help in accumulation formulas (Replacing above)
whiteline _ Aug 29, 2012 2:54 PM (in response to Cesar Accardi)You can add years to all of your sets:
{1<[Descrição do Subindicador]={'CUBPR'}, Year=P({$}Year)>}

Re: Help in accumulation formulas (Replacing above)
Cesar Accardi Aug 29, 2012 3:05 PM (in response to whiteline _)Thanks.
I tried this.... but I need to calculate the variation with a year (2010) that is outside of my selection. Any ideas?

Re: Help in accumulation formulas (Replacing above)
whiteline _ Aug 29, 2012 3:07 PM (in response to Cesar Accardi)I think, you can always use Only() over your expression with corresponding set expression.



Re: Help in accumulation formulas (Replacing above)
Cesar Accardi Aug 31, 2012 9:29 AM (in response to Cesar Accardi)Hi,
The problem was solved.. I used the Only() in the expression with AddMonths like you said however for this to work I must have 1 select value for year, as my client agreed with this, so that's ok.
Thanks for your help!