[b]CAN'T GET SUMMARY TO SHOW DECIMAL PLACE VALUES[/b] 1

[Nassy]

Hi

I have a really basic problem that is driving me mad.

I have a report which shows the Total Net Revenue for each Branch . Net Revenue is calculated using a formula and then I simply create a summary field based on this formula.

The values display correctly on the report. However when I change the formula to divide the values by 1000 (hence moving the decimal point) Crystal will not show the fractional part of the value.

For example


The Branch at ST Johns Wood has a net revenue figure of £5700 that shows on the report. However when I change the formula to divide this figure by 1000 the figure that is displayed is £5.00 instead of £5.70


I have changed the format field options to show decimal places 1.00 and rounding to be 0.1. I have played around with other rounding and decimal place options. But the fraction part is never shown.

Why? The Net Revenue field is recognised in Crystal as a currency field ie it is not an integer.

Any help on this would be much appreciated as I can't think of what the problem could be...



Thanks

Nassy

 

[lupins46]

Can you post the formula you are using that gives the wrong answer.

 

[Nassy]

Sure,

Here is some further info. The formula that calculates Net Revenue is beneath:



if {KPITransactionTypes.KPITransactionType}= 'Sale Agreed' and {@Current Week}='Current Week'
then {KPITransactions.NetRevenue}\1000


The formula {@Current Week} takes a Start Date parameter value (entered by the user) and works out if each date falls within the current week (Between the Start Date and the next 7 days). If it does then this formula returns the string 'Current Week'.

Again the formula can be viewed underneath.



IF {KPICalendar.KPIDate} IN DateSerial (YEAR({?Date}),MONTH({?Date}),DAY({?Date}))
TO DateSerial (YEAR({?Date}),MONTH({?Date}),DAY({?Date})+7)
THEN "Current Week"


The reason for having this formula is that my report also has to show summaries based on Month to Date and Year to Date as well so I cannot just use a standard record selection.

Cheers

Nassy

 

[lupins46]

You have a \ (integer divide) rather than /

 

[Nassy]

Lupins46,

I feel so dumb but I can't thank you enough. I possibly wouldn't have spotted that myself!

Cheers

Nassy