Crystal Rounding Issue

You could add a formula field that calculates your account totals using the INT function and then do your grand total on that formula field. It should then display the total value you want. I'm at a bit of a loss as to why you'd want to display the wrong total, but this should work for you.

You could create a formula field that uses the 'round' function to show in your details section. Then use that field to group on and summarize for the grand total. In your example above, the formula field value would be 100 for each group, so the total would come to the 300 that they want.

Nick

Sorry, I was trying to simplify the calculation for the example.  I am gathering the Accounts from a large range of Acct-Units.  So if I do the INT at the individual Acct-Unit / Account level the totals are way off.

Are you using a Formula field to display your line totals?

The data is being captured with 12 periods of data, so the first thing i do is create a field that captures the current period amount for that record. I then group the accounts together and display the Sum of the formula field. FYI...there are also 7 other columns of data on the line. (ie. Acctuals, Budget, Prior Year, Variance, YTD, LYTD, ...)

Create a formula that uses the truncate function in Crystal, then create a Grand Total based on the formula.

Truncate doe not seem to work either. Here is a example layout of the report. Each line has 8 sets of data.

Acct Group 1 (Acct 500000 - 550000 Summarized for up to 10,000+ Acct Units)
Acct Group 2 ...
Acct Group 3 ...
Total For Groups 1- 3

Acct Group 4
Total for Acct Groups 1-4

Acct Group 5
Acct Group 6
Acct Group 7
Total for Groups 5-7

Acct Group 8
Acct Group 9
Total for All Groups

You can also create a manual running total in your report based on the rounded value and then display it on any section you want.

In any crystal guide they tell you exactly how this manual running total is created. You may not need a reset total but you will need a dispaly total

The manual total can have the round function or use the round function or create the manual total.

 

How would that work? The total lines need to be a summary of the detail lines that are rounded. I can not find a way to use the running total on a summarized field.

I just thought of this...This is a Crystal rewrite of a RW100 report. In RW100 they use the option Sum Down.

 What Ruma is referring to is a method of creating your own running totals using formulas/variables.  It gives you the most flexibility but can be complex to develop/maintain.