Conditional / fixed fields

[sugra]

greetings,

Is there a way to set a condition for a particular field apart from in the query? For example, suppose I want a field/variable to sum the amount of products that fall under 2 categories Frozen Goods and Snacks, is there a way to set those conditions at the field level?

[iancr01]

Try

(category == "Frozen Goods" || category == "Snacks")?(amount):0

[mdahlman]

The idea is good. That might work in Groovy (I'm not sure). In Java this is not what you might think it is:
category == "Frozen Goods"

 

If the report is using Java syntax then you want something more like this:
(category.equals("Frozen Goods") || category.equals("Snacks")) ? ( $F{amount} ) : new Long(0)

 

Regards,
Matt