I have aproblem with pentaho report designer 2.0,with it I do a report with number fields. In this number fields i do a formula that sum some item of query.


select customer as cliente,sales1 as vendita1,sales2 as vendita2,sales3 as vendita3
from sales_of_year

in the report i show:


in numfields there is the formula ([vendita1]+[vendita2])/[vendita3]

if I do anteprime with report designer in excel the report work all and show all items, but if i publish my report in pentaho server and in the console i do a report in excel the report work but show all item except the numberfields that results null string
why not come out the result? anyone know why?

please help my, sorry for my english and thanks to all in advance