Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
It could be looking like
=sum({<T010_InicioVigencia = {"<=$(=max(Date))"}, DataFinalVigencia = {">=$(=min(Date))"} >} Price)
Hope this helps,
Stefan
It could be looking like
=sum({<T010_InicioVigencia = {"<=$(=max(Date))"}, DataFinalVigencia = {">=$(=min(Date))"} >} Price)
Hope this helps,
Stefan
Thank you.
It works perfect.