Forum Stats

  • 3,853,259 Users
  • 2,264,199 Discussions
  • 7,905,296 Comments

Discussions

how to Calculation in oracle apex classic Report as like (column1 - column2 = column3)?

Nobody_Basirul
Nobody_Basirul Member Posts: 5 Blue Ribbon
edited Sep 12, 2022 10:07AM in Low Code Development

SELECT EMPCODE,EMP_DESIG,DEPT_CODE,PRODUCT_ID,REQUEST_DATE,APEX_ITEM.TEXT(1,REQUEST_QTY) REQUEST_QTY,APEX_ITEM.TEXT(2) AS issued,APEX_ITEM.TEXT(3) AS balance FROM STORE_PRODUCT_ISSUED;

Tagged: