[RESOLVED]Running total Problem

[sacramento]

Hi:

I had create 5 Running totals in my Rpt...But the last running total have a problem I don't know Why,because he don't sum the records...
I had attached a picture with the problem marked in red...

Someone have any idea why this happens?

Thanks

[pnish]

I'm just guessing here... but maybe the field used to hold the running sum is too small to display the whole result. Try making the field larger.

[sacramento]

In fact the field was a little bit small...Now the value display...

Thanks

[sacramento]

Hi:

Sory to came back to this post but I have a Doubt concerning the same subject that is create a running total that was 3 fields to Sum...It is possible with running total?Wich way?

Thanks

[brucevde]

Create a Formula that returns the sum of the 3 fields.
Create the Running Total and use the Formula as its "Field to Summarize".

[sacramento]

That's it's I had done...I had create a formula to the 3 fields,but the problem that is the "Create Running Total Field" Box only appears fields from database and i can't select the formula I had create...

[brucevde]

Can you post the formula?

[sacramento]

Sum ({Listagemlancamentos.txredvalorliquido})+Sum ({Listagemlancamentos.txintvalorliquido})+Sum ({Listagemlancamentos.txnorvalorliquido})

[brucevde]

That formula will create a Grand Total of the 3 fields. A formula that already uses Sum cannot be used in a Running Total.

The formula should be based per record like so

{Listagemlancamentos.txredvalorliquido} + {Listagemlancamentos.txintvalorliquido} +{Listagemlancamentos.txnorvalorliquido}

[sacramento]

Yes you are right...Now I can see the formula in the box and I can Add in the "Field to summarize"


Thanks