| capture the last accumulated column [message #406141] |
Tue, 02 June 2009 08:31  |
|
|
Hi can anyone tell me how i can capture the last accumulated value from the report.I m using one formula column as below.
begin
IF NVL(:CS_SRNO,0) < 1 THEN
:CP_RUNNING_BAL:=0;
ELSE
:CP_RUNNING_BAL:=NVL(:CP_RUNNING_BAL,0)+NVL(:STOCK_QTY,0);
:CP_1:=:CP_RUNNING_BAL;
END IF;
RETURN 1;
END;
what i am doing is i am checking the serial number.if the serial number is greater than 1 it will add the cumulative totals of stock_qty.but the requirement is i want to find the percentage %of each cumulative total that is last cumulative value / line cumulative value.is that possible.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
