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.
In IBM Cognos BI, database functions are organized in two folders, Common Functions and Vendor Specific Functions. IBM Cognos Series 7 ImpromptuÂ® functions are migrated as follows: If a corresponding IBM Cognos BI common function exists, it is used to map the Impromptu function for all databases.