[Stackoverflow] [Progress OpenEdge ABL] How to calculate total sum in one field in progress 4GL?

Status
Not open for further replies.
T

Thiru Malai

Guest
I have written a query for calculating total sum in one field but i could get total records. Let me share what i written.

DEFINE VARIABLE I AS INTEGER NO-UNDO.
FIND FIRST shth_pus_head WHERE shth_pus_head.push_id = "P0000078" NO-LOCK
NO-ERROR.
FOR EACH shtd_pus_det OF shth_pus_head NO-LOCK:
i = i + 1.
END.
DISPLAY i.


What i need is when i calculate total sum in qty column i want sum = 1560.

(Note- qty column table field is shtd_pus_det.qty)

Check the attached image

Continue reading...
 
Status
Not open for further replies.
Top