In a triangle, we use terms like adjacent and opposite. These refer to sides in relation to angles. In our musical triangle, the drummer is at one angle in the back. This side, where the audience is, is called the opposite side.
Trunc is database function, try using round for numeric values, or change the Processing of Query to database.
TRUNC (date) The TRUNC (date) function returns date with the time portion of the day truncated to the unit specified by the format model fmt. The value returned is always of datatype DATE, even if you specify a different datetime datatype for date. If you omit fmt, then date is truncated to the nearest day.