Subselect field, how to address sub-field, such as testing if it's less than a value

Applications Report PDF
#1

Hi, hope you’re doing well.

Let’s suppose I have an invoice pdf report with fields:


invoiceid
date
customerid
product(subselect)
      productid
      unitprice
      quantity
      amount

I want to place a box around the unitprice values when they are less than 100. I know how to place the box around the number …
But how do I do the testing, for example:

if ({product.unitprice} < 100)
{
…
}

Above not working. Please help.
Is {product.unitprice} not correct as referencing the field. How to reference the field unitprice?.

#2

On Record … exactly like that … but enclose 100 in single quotes…
if ( {product.unitprice} < ‘100’ )
{
echo “YES IT IS!” ;
}