a little question. - Forum - Community Groups - Progress Community

a little question.

 Forum

a little question.

  • 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...

  • Have a look at the ACCUMULATE / ACCUM functions.