sales opportunity amount sum of one month

[former_member229757]

Hi Friends

I want to generate a query of sales opportunity only won opportunities status. One month sum of all the amounts

query:

select sum(t0.maxsumloc) as tot from OOPR t0 where t0.slpcode='8' and t0.OpenDate between '01-15-17' and '02-15-17' and t0.Status='w' group by t0.slpcode,t0.OpenDate

Its showing 3 lines of sum . I need sum in single line

Thanks

Vinoth

[agustin_marcoscividanes · Accepted solution]

Hi

I would try the same sql query but I delete the group by clausule.

Kind regards

Agustín

[kothandaraman_nagarajan]

Hi,

Try this,

select sum(t0.maxsumloc) as tot from OOPR t0 where t0.slpcode='8' and t0.OpenDate '01-15-17' and '02-15-17'
and t0.Status='w'

Regards,

Nagarajan