Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1231
  • Last Modified:

Crystal Report 3 formula trick - calculation formula


I am trying to complete a 3 formula trick to calcalate a grand total from a group total.

so far so good except I seem to have a road block in the calculation formula and get an error that a 'Number" is required here when I drop in my group total field to calculate.  I have tried to use a conversion to no avail.  And that field data type IS a number in the report.

See attached.

thanks

CR-3formtrick-number-required.jpg
0
BioTechManic
Asked:
BioTechManic
  • 3
  • 2
1 Solution
 
gordon2011Commented:
The problem is that according to your formula, you are trying to sum the Company name - which will cause an error. Unless I'm missing the point, if it's a grand total then you don't need to sum the group totals, just sum the individual field.

If you want to know the total at specific points, then try a running total.
0
 
BioTechManicAuthor Commented:

Gotcha - That is what I figured...but have tried many variations on this.

Running total won't work on a summarized field in a group...I so wish it would - hence using the 3 formula trick - I am CR9 btw.

When I try to use the actual field amount, which is a currency datatype, I get the same error - see attached... Error
0
 
mlmccCommented:
I would guess that Activity.Amount is a currency.

Try this

WhilePrintingRecords;
Global CurrencyVar GrandTotal;
GrandTotal := GrandTotal + {Activity.Amount};


The other way would be to convert the amount

CDbl({Activity.Amount})

mlmcc
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
mlmccCommented:
gordon2011 - Sum({Activity.Amount},{Name.Company})
That calculates the sum of Activity.Amount over the group for a company.
It limits the values in the sum to the records for the company.  Other wise it will sum all values in the report.

mlmcc
0
 
BioTechManicAuthor Commented:
changing to Global CurrencyVar did it!! wow - I knew I was close - funny how it would not let me change the data type within the last statement on the calculation formula - I did have to go into all 3 formulas and change the GrandTotal variable datatype to currency and then I could put in the formula that calculated the group totals and wallah - it worked.

thanks

now I think I am supposed to do something with points...I dont do this often - once a year or so.....
0
 
BioTechManicAuthor Commented:
awesome - thanks
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now