Sum by period in Crystal Reports

Asked

Viewed 996 times

0

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

For example:

 SUM(Relatorio.Faturamento, DATE(2015,01,01) to {?DataFinal})

1 answer

1


A solution may be :

Create a formula f_soma In the rule

If [Relatorio.data] >= DATE(2015,01,01) and Relatorio.data <= {?DataFinal}) Then
  Relatorio.Faturamento
Else
  0

In the report use the formula f_soma as aggregator

  • That’s exactly what I needed. I made the formula based on what I answered and made a summary based on it. !

  • Formula in CR does not make dinner but heats up in the microwave ... :)

  • Beeeeeemmm out there! Hahaha

Browser other questions tagged

You are not signed in. Login or sign up in order to post.