> Hi:

> Problems with Report

>

> Suppose you have a table: SALES.DBF with a field: price_1 (Num 8,2) and some 800 records.

> Then in the Report footer you put a numerical field: price_1 and calculation sum it.

> In the Report Expression you put INT(price_1/5). Divide by 5 to get some decimals

>

> Somehow the INT() integer funtion does not work.

> It gives you a wrong number. I have gotten a diference of 3.

> For example the value without INT is like 31.567, and the value with INT() is like 29.

>

> Please if anyone can help I will appreciate it.

>

> Thanks.

Hi,

I'm not sure if understood your question.

If you add int(price/5) into report expression and sum it, it will sum int-egered values.

If you need int() the result, add a variable to report, sum it, and on the footer put int(m.var/5) without summing.

hth

Martin