Round up and Truncate 1

[PJOL]

We have a report with a total that's not an actual field, i.e. it's a sum calculated from sub-totals from other fields. I need to round it up or truncate it in our favour, i.e. 5.1 rounded up to 6 and so on. There is a formula for this in Crystal for fields, but I'm having difficulty applying it to a sum total. Any help appreciated.

 

[lbass]

You should always share contents of your formulas. Anyway, create a formula like this:

-int(-{@yoursummary})

Use this instead of {@yoursummary}.

-LB

 

[PJOL]

The output I want to truncate is a Sum field object as follows:

Sum of @UOM GI (number)

The @UOM GI (number) is a conversion formula as follows:

{PLANNING_JOB_STAGE_LINES.INPUT_QTY_STD_BATCH}/{PART_UOM_CONVERSIONS.UOM_CONVERSION_FACTOR}

 

[lbass]

Then the formula would be:

-int(-sum({@UOM GI})) //if the sum is a grand total, or

-int(-sum({@UOM GI},{table.groupfield}))//if it is a group total

-LB