How do I use the SUM function in a period specified in the?
For example:
SUM(Relatorio.Faturamento, DATE(2015,01,01) to {?DataFinal})
How do I use the SUM function in a period specified in the?
For example:
SUM(Relatorio.Faturamento, DATE(2015,01,01) to {?DataFinal})
A solution can be:
Create a formula f_soma In the
If [Relatorio.data] >= DATE(2015,01,01) and Relatorio.data <= {?DataFinal}) Then
Relatorio.Faturamento
Else
0
In the report use the f_soma formula as aggregator