Hi,
I am trying to add two fields in select and getting this message. Any help is appreciated.

Select new Item( item.name,(item.amount+item.tax))
from item

On executing this I am getting the following error

aggregate function expected before ( in SELECT

Can we use "+" operator in select clause

I believe you cannot use '+' in select.
Look at the 'formula' attribute in property (.hbm).

Are you try
Select new Item( item.name,item.amount+item.tax)
from item

or simple add getter in POJO like
getTotal() {
return amount + tax;
}

regards

You might be use derived property if needs.