Help with Addmonths

[antoniodneto]

Hi Guys

I have this expression to the value of my MAX DATE FIELD.

=sum({$<STAGE_IFRS9_FINAL_X={'Stage 1'},Carteira_IFRS_ATUAL={'EMPRESAS_1','EMPRESAS_2','EMPRESAS_3'},MOTIVO=-{'Fora Escopo Anterior','Saiu do Escopo','Se mantém fora do Escopo','Fora Escopo Atual'},DATA_BASE_FINAL={"$(=(MAX(DATA_BASE_FINAL)))"} >} EAD_ATUAL)/1000000

How Can I write another expression returning the previous month of MAX DATE?

I'm trying using Addmonths but not sucess. You guys think another way to solve that?

Tks a lot!

[OmarBenSalem]

+

can u share how u've constructed ur variation measure?

[antoniodneto]

Hey Omar,

Now is working. Actually I used the expression as numeric not percentage.

(

sum({$<STAGE_IFRS9_FINAL_X={'Stage 1'},Carteira_IFRS_ATUAL={'EMPRESAS_1','EMPRESAS_2','EMPRESAS_3'},MOTIVO=-{'Fora Escopo Anterior','Saiu do Escopo','Se mantém fora do Escopo','Fora Escopo Atual'} >} EAD_ATUAL)/1000000

-

Above(

sum({$<STAGE_IFRS9_FINAL_X={'Stage 1'},Carteira_IFRS_ATUAL={'EMPRESAS_1','EMPRESAS_2','EMPRESAS_3'},MOTIVO=-{'Fora Escopo Anterior','Saiu do Escopo','Se mantém fora do Escopo','Fora Escopo Atual'} >} EAD_ATUAL)/1000000

))

Thank you so much!!!