Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All
I have table invdet which has inv_docpayamt column this is total of header which is repetaing with details total
now i want to display only one time 65063 amt with details table , Whether this is possible in QV. I have attach
QV file also
Advance Thanks.
Regards
Vikas
use distinct function might be helpful
like
sum(distinct inv_docpayamt)
hope it helps you
Hi Vikas,
Come up with an example output required, then it is easier to understand what you required, It is possible.
Regards,
Jagan.