Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get Difference of a two Records of Same Colums Sum

I am Having Data Like Following..

DataBaseSTORE CCODEGROSSDISCOUNT
CO12250122855120600215
ReSA12250122855120600215
CO13521234821232552310
ReSA13521234821232552310

I want to Show the Difference of GROSS between two DataBases for particular Store, as well as for DISCOUNT also.

Please help me to get this.

1 Reply
Gysbert_Wassenaar

How about: max(GROSS)-min(GROSS)


talk is cheap, supply exceeds demand