We have software that uses Crystal to generate Reports for us. Some of my clients need info changed on these reports. Easy enough, so I thought...

 

We are in the woodwork industry. My one client sells board in sheets. They do cut and edge. Now my problem is, I can't get the report to round up the boards from, lets say, 2.35 to 3 sheets. I have tried using the format field but it did not work.

 

The formula that was created is as follows:

 

numbervar total;
total := {@SumtotalsNumber} + ({@SumTotalsNumber} * ({tbl_Material.Waste} / 100));

if {@RoundTotals} then
    if total - truncate(total) <> 0 then
        total := truncate(total) + 1
    else
    total := total;

total

I understand that truncate takes the value down instead of up. How can I change this?

 

Thanks in advance.

 

Willem