Summing Running Total Field with Condition 1

[NBVC]

Hi,

I am trying to conditionally summarize a Running Total Field

Here is the formula I came up with to date:

Sum ({#rtot_acct_opening_bal},ToNumber (Left ({ACCOUNT.ID},4 ))>=3000 )

It says it's not valid because it can't summarize the #rtot_acct_opening_bal field, which is a running total...

How can I accomplish this..

I am trying to summarize the #rtot_acct_opening_bal field only where the left 4 digits of the ACCOUNT.ID field is greater than or equal to 3000.

Thanks.

 

[IanWaterman]

Create a new running total for acc_openingbalance.

In the evaluate check the formula box and enter

ToNumber (Left ({ACCOUNT.ID},4 ))>=3000

Ian

 

[NBVC]

What should I put in the "Field to Summarize" field? It doesn't show/allow the #rtot_acct_opening_bal field as an option.

 

[IanWaterman]

Whatever you have in the current #rtot_acct_opening_bal

Ian

 

[NBVC]

Thank you, that is what I thought... it was a stupid question, I guess.. but your answer validated my guess...

Thanks very much for the prompt assistance.