Getting summary of mutltiple fields

[aus0137]

Database has 12 fields for budget for each year,

Such as budget01, budget02,,,budget12 etc.

When getting a YTD budget figure, based on a month parameter, I usually create a formula like,

if month = 03 then budget01+budget02+budget03 etc.

By the time you get to period 12, you have 12 lines and each line is quite large.

Is there a way to sum the fields?

ie for period 03 - September
a formula something like
sum budget01 to budget03

or for period 12,
sum budget01 to budget12.


Appreciate your help.

 

[crystalreporting]

Not that I'm aware of - Crystal does not and can not know the syntax and naming conventions of the underlying database - so it cannot assume that all of the budgetXX fields would have the same syntax. One way or another, you'll have to reference them individually.

Peter Shirley

http://www.linkcorp.com