Please help me with formulas reverse to summarizing:
Placed in Group Header:
//{@resetBalnce}
whileprintingrecords;
numbervar payment;
numbervar cancelled;
numbervar refund;
numbervar balance_sum;
payment:=0;
cancelled:=0;
refund:=0;
balance_sum:=0;
----------------------------------------------------------------------
//{@accum}
placed in the detail section:
whileprintingrecords;
numbervar approved:= {accounting_report_vw.approved_grant_amount};
numbervar payment:= payment + {accounting_report_vw.payment_gross_amount};
numbervar cancelled:= cancelled + {accounting_report_vw.ADJ_CANCELLATION_AMOUNT};
numbervar refund:= refund + {accounting_report_vw.ADJ_REFUND_AMOUNT};
numbervar balance_sum;
balance_sum:= approved - payment - cancelled + refund;
balance_sum
---------------------------------------------------------------------------
//{@displayBalance_Sum}
placed in the group footer
whileprintingrecords;
numbervar balance_sum
I need to display:
Approved Paid Cancelled Refund Balance
100000 50000 2500 2500 50000
50000 1300 1300 0
Total by Group 100000 100000 3800 3800 0
First line is OK but I receive negative numbers in the next lines.
Please help me with the formulas. Thanks!!
Placed in Group Header:
//{@resetBalnce}
whileprintingrecords;
numbervar payment;
numbervar cancelled;
numbervar refund;
numbervar balance_sum;
payment:=0;
cancelled:=0;
refund:=0;
balance_sum:=0;
----------------------------------------------------------------------
//{@accum}
placed in the detail section:
whileprintingrecords;
numbervar approved:= {accounting_report_vw.approved_grant_amount};
numbervar payment:= payment + {accounting_report_vw.payment_gross_amount};
numbervar cancelled:= cancelled + {accounting_report_vw.ADJ_CANCELLATION_AMOUNT};
numbervar refund:= refund + {accounting_report_vw.ADJ_REFUND_AMOUNT};
numbervar balance_sum;
balance_sum:= approved - payment - cancelled + refund;
balance_sum
---------------------------------------------------------------------------
//{@displayBalance_Sum}
placed in the group footer
whileprintingrecords;
numbervar balance_sum
I need to display:
Approved Paid Cancelled Refund Balance
100000 50000 2500 2500 50000
50000 1300 1300 0
Total by Group 100000 100000 3800 3800 0
First line is OK but I receive negative numbers in the next lines.
Please help me with the formulas. Thanks!!