a little question.

Posted by rogeliolt on 11-Jan-2013 18:20

hi people... is to late but... HAPPY NEW YEAR... .

I'm create a little report for my tables, but i can´t show the results for different keywords, example.

for each table1 where table1_date_w = today

                         and table1.cash > 0,

first table2 where table2.id = table1.id

                 no-lock break by table2.instr.

  if last-of (table2.instr) then do:

    display

       table2.id

       table2.date_oper

       table2.cust

       table2.instr

       table2.cash

       total_csh.

  end.

end.

I need show this result

iddate_opercustinstrcashtotal_csh
528/09/2012123456A1,50001,500
828/09/2012963852A3,00004,500
1528/09/2012123987B250250
2201/10/2012456987B1,5001,750
3505/10/2012123654C2,5002,500

How I can show the results like the column 'total_csh' where the price is 0 and calculate when the instr change.

Can you help me???... pelase...

All Replies

Posted by Admin on 12-Jan-2013 05:03

Have a look at the ACCUMULATE / ACCUM functions.

This thread is closed