Summary Error

[Schnappa]

Hi all

I had an error stating - A summary has been specified on a non-recurring field. The calculation in question is

@Interest_Paid which is.....
(({@Weighted_Value} * ({?Delivery_Rate}/100))/{@Days_in_the_Year})*{@Days_in_Month}

@weighted_Value is...
((Sum ({AccountTransactions.TranAmount}) * 13) + ({Account.CurrBalance} * ({@Days_in_Month} - 13)))/{@Days_in_Month}

@Days_in_the_Year and @Days_in_the_Month are pretty self explanatory, while ?delivery rate is just a percentage.

I have this grouped by Account_ID and the fields required are all in the footer of this group. The transactions make up the details section of the report, and are linked via the Client_ID.

I am running CR10 & Access.

Hopefully someone is able to make out my scrawlings and come to my aid. TIA

Gez

 

[synapsevampire]

@Days_in_the_Year and @Days_in_the_Month may be pretty self explanatory, but you need to share what's in them because that's probably the problem.

-k

 

[Schnappa]

OK - Sorry about that. The two fields are based on parameters and are below (forgive the inexperience)

@days_in_Month is....
if {?Leap Year Check} = False
then select {?Month Name}

case "January", "March", "May", "July", "August", "October", "December":
31
case "April", "June", "September", "November":
30
case "February":
28
else select {?Month Name}
case "January", "March", "May", "July", "August", "October", "December":
31
case "April", "June", "September", "November":
30
case "February":
29

@days_in_the_Year is....

if {?Leap Year Check} = false
then 365
else 366

Cheers

G

 

[synapsevampire]

Odd that you're using parameters for Leap Year and month...

Also shouldn't the summary functions use the group qualification:

Sum ({AccountTransactions.TranAmount},{AccountTransactions.AccountID})

It doesn't jump out at me why it says something is non-recurring, I'll look again in the morning.

-k

 

[Schnappa]

Thanks for that...

Any particular reason why it is odd to work it out that way. Maybe due to the fact I am self taught, and I probably dont follow any particular methods, I can do things in an 'ancient' way. Any help would be appreciated.

G