Sum by date in Crystal Reports

0

How do I use the SUM function in a period specified in the?

For example:

 SUM(Relatorio.Faturamento, DATE(2015,01,01) to {?DataFinal})
    
asked by anonymous 16.01.2015 / 17:37

1 answer

1

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

    
16.01.2015 / 18:24