Opening balance = 1000
KGS BALANCE
100 900
100 800
50 750
I used here formula:
Temp number;
temp :=
pening balance - :KGS return (temp);
this formula is working but I could not get proper balance.
Which formula I should use in Balance field.
Please help in this regard.
i am using this code
but row 2 not showing balance.
function CF_3Formula return Number is
bal number;
begin
if :cs_row = 1 or :cs_row =0 then
bal:=:cf_2-:cf_1 ;
return (bal);
elsif :cs_row > 1 then
return(bal);
end if;
end;