Truncating a crosstab summarized field

[jowilliams]

I need to truncate a summary field in a crosstab - the field in question is a formula that calculates a number to 2 decimal places.

I need to display the summarized field (sum of the formula) on the report as truncated but I do not want to truncate until after the summarization is done because I need the decimal portion to be included in the summarized amount for accuracy.

Is there some way of truncating the output of the crosstab after it has summarized the data? I've tried sticking a truncate expression in the 'Rounding' portion of the format editor for the field in question but it doesn't work If I stipulate no decimal places in the 'Decimals' format it, naturally, rounds my summarized field up, when my goal is to round it down.

thanks,
Jo

 

[kenhamady]

I am afraid that there isn't a way to do that. You can't apply any functions to a cross-tab value, and the only rounding you have control of is the number of decimals. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)