How to sum a single fiscal period for monthly expenses and also sum ytd expenses

Here's a suggestion to start:

Create 3 formulas: Period1, Period2, Period3.

Here's the code for each formula, substituting the correct table name

and months for each:

If {table.Month}=1 or {table.Month}=2 or{table.Month}=3 then

{table.ExpenseAmt}

Place all three formulas in the correct section and suppress them.

Then create a sum for each formula.

When added (SumPeriod1+SumPeriod2+SumPeriod3), you should get YTD.

Maybe I'm completely off from what you want, but it's the first idea that

came to mind.

Paul Benner

Quote:

> Hi everyone,

> I have a problem I'm hoping someone can help me with. I need to include

> both monthly and ytd expenses for a department expense report. If I allow

> the user to enter the period as an input parameter in order to determine

> monthly expenses(i.e. period 3), how can I then get and sum all the

entries

> for a department for the fiscal year(i.e. for period 1 + 2 +3)? I'm

really

> puzzled by this one--any suggestions would be much appreciated.

> Thanks,

> Sue