Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bom dia, Senhores:
Tenho esta expressão funciona:
Ela me retorna dia 01/04/2016 a 08/04/2016
Sum({$<Ano ={$(=Year(today()))},Mês={$(=Month(today()))}, [operacao]={'V'} >}valor)
Preciso da mesma expressão ele me retornando.
01/04/2015 a 08/04/2015
Qual ficaria?
Cara existem diversas formas de se realizar esta expressão. Segue uma
=Sum({<Data= {'>=$(=AddYears(Monthstart(Today()),-1))<=$(=AddYears((Today()),-1))'}, [operacao]={'V'}>}valor)
May be this:
Sum({$<Ano = {$(=Year(Today() - 1))}, Mês = {$(=Month(Today()))}, Day = {$(='<=' & Day(Today()))}, [operacao]={'V'} >}valor)
Alternatively, you can use Date:
Sum({$<Ano, Mês, Day, Date = {"$(='>=' & Date(AddYears(MonthStart(Today()), -1),'YourDateFieldFormatHere') & '<=' & Date(AddYears(Today(), -1),'YourDateFieldFormatHere'))"}, [operacao]={'V'} >}valor)
did not work, I need the previous year and the month in the same hazard
What is your dimension? Date or MonthYear?
Working on this?
Sum({$<Ano ={$(=Year(today()))},Mês={$(=Month(today()))},Dia={$(=Day(today()))}, [operacao]={'V'} >}valor)
Ano = Year
Mês = Month
Dia = Day
Data: Date
Sum({$<Ano ={$(=Year(today()))},Mês={$(=Month(today()))}, [operacao]={'V'} >}valor)
I need you to back me the year and month the previous year. (Proprocional)
Exemplo: Periodo acima: 01/04/2016 a 08/04/2016
Meta: 01/04/2015 a 08/04/2016
Yes
I need to compare year and Mes 2016 and Year and Month 2015
Is this a pivot table or straight table? What are/is the dimension/s?