Hi all,
Is there a simply way to do this, i need to sum and to substract the value from one column if the other have 'D' or 'C' i can do that with scan endscan, but if the grid have some records it could be slow. The total is outside the grid. The grid is based in a view.
Thank's
João Batista
Example:
Column1 Column2
1000.0 D
500.0 C
Total - 500.0