Average Sales in the last 30 days - Fixed Report

[Ribeiro]

I need to find the Average Sales (VND) last 30 days.

I need to put set Analysis 2 in Set Analysis 1

How do I put the average of the last 30 days in a fixed report?

Any suggestion...

Set Analysis: 1

sum({$<Ano ={$(=Year(today()))},Mes={$(=Month(today()))},Dia={$(=Day(today()))},[Tipo]={'OTE'} >}Qtde)

Set Analysis: 2

Avg({<Data={">=$(=Date(Max(Data) - 30, 'D/M/YYYY'))"},[Tipo]={'VND'}>}Qtde)

set analysis 1 +  set analysis 2

CodigoProduto	Data	Tipo	Sequencia	Qtde
1	28/10/2017	OTE	400	10
1	28/10/2017	VND	401	1
1	15/10/2017	VND	399	3
1	15/06/2017	VND	288	6
1	31/09/2017	VND	381	3
1	03/10/2017	VND	401	3
1	15/08/2017	VND	285	2

[sunny_talwar · Accepted solution]

May be this

If(sum({$<Ano ={$(=Year(today()))},Mes={$(=Month(today()))},Dia={$(=Day(today()))},[Tipo]={'OTE'} >}Qtde)<> 0,

AVG(TOTAL <CodigoProduto>{$<Ano ={$(=Year(today()))},Mes={$(=Month(today()))},[Tipo]={'VND'}>}Qtde))

[Ribeiro]

Many thanks, perfect ....

[Ribeiro]

I need to bring the stock. But he's adding up.
I think I need to handle the set analysis to handle the stock
See that the inventory table relates this to another normal and in the other it is adding ...

qvw is up 210x

Correct Stock

GG = 1

P = 3

Is Stock bringing 10?

If(sum({$<Ano ={$(=Year(today()))},Mes={$(=Month(today()))},Dia={$(=Day(today()))},[CodigoFilial]={'2'},[Tipo]={'OTE'} >}Qtde)<> 0,

sum(TOTAL <CodigoProduto>{$<Data={">=$(=Date(Max(Data) - 1000, 'D/M/YYYY'))"},[CodigoFilial]={'2'}>}Estoque))

[sunny_talwar]

Try this

If(sum({$<Ano ={$(=Year(today()))},Mes={$(=Month(today()))},Dia={$(=Day(today()))},[CodigoFilial]={'2'},[Tipo]={'OTE'} >}Qtde)<> 0,

sum(TOTAL <CodigoProduto, NomeTamanho1>{$<Data={">=$(=Date(Max(Data) - 1000, 'D/M/YYYY'))"},[CodigoFilial]={'2'}>}Estoque))

[Ribeiro]

Obrigado.