Grand total of formula fields

Hi, any help would be appreciated.  Crystal Reports V8.5. This subject has been covered many times but I cannot quite get to grips with it. Very simply I have a report that has a formula field called @balance:

ToText ({ReportData.Award}-{ReportData.SumOfPaidAmt})

for each record it prints this calculated amount. (the SumOfPaidAmt is a total within each record)

I think I need to use running totals, but I do not a 'running total' only a grand total.
All I want to do is show a grand total of @balance at the bottom of the report.

Many thanks.
robfendergibsonAsked:
Who is Participating?
 
bdreed35Connect With a Mentor Commented:
You have a few options.

One, you can create another formula to put into the report footer.
The formula should look like this:

Text (sum({ReportData.Award})-sum({ReportData.SumOfPaidAmt}))


Second option, you can alter the balance formula by getting rid of the ToText function.
Not quite sure why you are using it anyway.
@balance:

{ReportData.Award}-{ReportData.SumOfPaidAmt}

Now you can right click it and insert a grand total summary off of it
There are other options to, but one of these 2 would server you best.
Personally, 2 would better in my opinion.
0
 
SpykairCommented:
Move that formula field into your report footer. Should sort out your problem

Hth,
Spykair
0
 
robfendergibsonAuthor Commented:
Thanks Spykair but if I move the @balance formula field into the report footer, I do not get the total amount of @balance, I only get the last record result amount.  Do I need to do anything else?  Each record caculates the outstanding balance (@balance formula field) by subtracting 'total payments' (SumOfPaidAmt) from Award amount.

I guess another way of putting it is that I need a total of: (total of Award Amounts - total of balance amounts)

thanks,
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
SpykairCommented:
bd's got it spot-on

Spykair
0
 
Ken TurnerCommented:
Why does ({ReportData.Award}-{ReportData.SumOfPaidAmt}) have to be converted to text?

If it wasn't, creating the grand total would be trivial.
0
 
robfendergibsonAuthor Commented:
Many thanks for this, yes it was easy in the end.  the Totext (mmm not sure why it was in there..) was stopping me summing the easy way.  I've taking the ToText out and all works fine.
0
 
Ken TurnerCommented:
robfendergibson:  you probably now need to decide which one of we correspondents is to be the lucky recipient of your 250 points ...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.