Calculating fractional scores so they equal a whole number

[dfaith]

Perhaps someone out there has a solution for this one:

I am writing a report that calculates scores on 6 different areas based on employee performance. There are 3 different sections in each category and the score is calculated by dividing the category score by 3. As a result, it is possible to get a category score that is a decimal value which doesn't add up to the total score for the category.

Is there any way to do this without losing the decimal portion of the score and therefore artifically raising or lowering the score?

For example, Score for Category A: 76
Score for Section 1: 25.33
Score for Section 2: 25.33
Score for Section 3: 25.33 = 75.99 not 76

I'd appreciate any help you can give on this one.

 

[synapsevampire]

Not knowing anything technical, such as the data type makes this a bit tricky, but it may be just a formatting concern, try right clicking the number and select format field->Number and adjusting the decimals and rounding.

Otherwise post where these values exist in the report (such as a group level, the details?), what type they are, the actuqal formula you're using to display, etc.

Note that the output shows 2 digits of precision for each element, so why would the total be any different?

If you're using a totext() function to display the value, try using:

totext({@formula},"",2)

-k

-k