Set Analysis function

[#1]

Hi all, I want to translate the sentence below to set analysis.

=if(Date(T010_InicioVigencia,'DD/MM/YYYY') <= Date(max(Date) ,'DD/MM/YYYY') and Date(DataFinalVigencia,'DD/MM/YYYY') >=  Date(min(Date) ,'DD/MM/YYYY'),sum(Price),'')

Prety much like that.

sum({$<Ano_Emissao_Documento= , Ano_Cancelamento_Documento={$(vAnoEmissao)}>}Price)

any clues???

thanks

[swuehl · Accepted solution]

It could be looking like

=sum({<T010_InicioVigencia = {"<=$(=max(Date))"}, DataFinalVigencia = {">=$(=min(Date))"} >} Price)

Hope this helps,

Stefan

[#3]

Thank you.

It works perfect.