Developer6i: Dividing matrix report cell values by a summary value
From: Aamir Abbas <aamir_abbas_at_intervoice.com>
Date: 19 Feb 2002 14:42:14 -0800
Message-ID: <1afdd75f.0202191442.5a0f6d1_at_posting.google.com>
Date: 19 Feb 2002 14:42:14 -0800
Message-ID: <1afdd75f.0202191442.5a0f6d1_at_posting.google.com>
Schema: SCOTT Table: EMP MATRIX REPORT Fig 1 Actual values from the EMP table JOB ANALYST CLERK MANAGER PRESIDENT SALESMAN TOTAL DEPTNO 10 1,300 2,450 5,000 8,750 20 6,000 1,900 2,975 10,875 30 950 2,850 5,600 9,400 total: 6,000 4,150 8,275 5,000 5,600 29,025 Fig 2 The computations for the output look somewhat like the fig below where each cell value of the report in fig 1 is divided by the total sum of the values of that row. JOB ANALYST CLERK MANAGER PRESIDENT SALESMAN DEPTNO 10 1300/8750 2450/8750 5000/8750 20 6000/10875 1900/10875 2975/10875 30 950/9400 2850/9400 5600/9400
Is this possible in Developer6i? How? Received on Tue Feb 19 2002 - 23:42:14 CET