I have the data as follows
"code" "id" "amt"
SSIPP 99995 100
W2TAX 99994 500
PS 99994 500
ES 99994 500
i want to summurise on the field "amt" and get the total 600 with respect to id.
but iam getting 1600. how do i write the formula.
I have to place the grand total 600 in the page header as state grand total.
any help is appreciated.
Thanks.
"code" "id" "amt"
SSIPP 99995 100
W2TAX 99994 500
PS 99994 500
ES 99994 500
i want to summurise on the field "amt" and get the total 600 with respect to id.
but iam getting 1600. how do i write the formula.
I have to place the grand total 600 in the page header as state grand total.
any help is appreciated.
Thanks.