Balance for specific year

[rpp]

There're 2 tables:

- 'Years' contains 2 years (for example)

- 'Sum for Year' contains a fild with Numbers.

And a summary fild -- Total of all these Numbers.

And of course there's relation between these tables.

The task is:

to get Total (in 'Sum for Year') for the Found Set 'Year'=2005 (f.ex.) in 'Years'

I'm a novice & cannot find any information how to organize this operation.

Thanks.

test.zip

[Breezer]

I think this is what you wanted.

test.zip

[rpp]

Thanks a lot, Breezer!

But the stucture was changed -- I think I didn't describe the problem sufficiently.

Years were: 2005, 2006, 200_5_

(These are invoices; invoice dates, not a list of years). Now that's a list of 3 years: 2005, 2006, 2007

The idea was: based on an invoice year/date (in 'Years' containing many invoices (Names, Origin, etc.), f.ex. 2005, to select/find operations in 'Sum for Year' for these invoices/year & to get a sum for this period.

Edited January 9, 2006 by Guest

[rpp]

Thanks, Breezer!

Based on your solution, I decided the problem.

My version is attached.

test.zip

Edited January 10, 2006 by Guest

[Fei Long]

Can we use this to calculate previous month's total and use it as balance bring forward for the next month ? How do we do it in this case?

[Fei Long]

Anyone can help me on this ?

[Søren Dyhr]

Yes, but the Search1 field should contain complete dates that should be joined via less or equal operator in the relations def.

We should instead have a relational leg more in the fork, the keyfield definitions could be made like this...

1) previous month startdate:

Date ( Month ( Get ( CurrentDate ) ) -1; 1 ; Year ( Get ( CurrentDate ) ) )

2) previous month end date:

Date ( Month ( Get ( CurrentDate ) ) ; 0 ; Year ( Get ( CurrentDate ) ) )

--sd

[Fei Long]

Thanks SD for helping. But I still don't get the way you mentioned to implement it into my solution. What I need is shown in the file I attached.

balance.zip

Edited April 13, 2006 by Guest

[Fei Long]

Anyone can help me on this ? Thanks in advance. Sorry for the double post since I am desperately need solution for this matter.