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
Printable View
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
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.
In fact the field was a little bit small...Now the value display...
Thanks
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
Create a Formula that returns the sum of the 3 fields.
Create the Running Total and use the Formula as its "Field to Summarize".
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...
Can you post the formula?
Code:Sum ({Listagemlancamentos.txredvalorliquido})+Sum ({Listagemlancamentos.txintvalorliquido})+Sum ({Listagemlancamentos.txnorvalorliquido})
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}
Yes you are right...Now I can see the formula in the box and I can Add in the "Field to summarize"
Thanks