Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sum of field based on date
Message
From
16/09/2006 21:16:19
Erick Miranda
Formata Data Business - Grupo Linx
Contagem, Brazil
 
 
To
16/09/2006 18:57:47
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01154432
Message ID:
01154439
Views:
12
Hi Boban,

>I have a table used in report with two fields SOMEDATE and SOMENUMBER.
>
>I have made group by SOMEDATE in report.
>
>I want in group footer to show total SUM of SOMENUMBER for dates before date that is current in group.
>
>How to do that? (preferably it would be variable)

If I didn't mistake. I think that these steps can help you:
- Create a new variable and in Value to Store put SOMENUMBER.
- Set Calculate to "Sum" and Reset At to "End of Report"
- Put a Field in Group Footer and put your variable's name.
Note: This can to be done directly in Field.
Good luck!
Erick
Força Sempre!
Strength Always!
Previous
Reply
Map
View

Click here to load this message in the networking platform