Skip to Content

sales opportunity amount sum of one month

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 15, 2017 at 12:08 PM

    Hi

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

    Kind regards

    Agustín

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 15, 2017 at 01:52 PM

    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

    Add comment
    10|10000 characters needed characters exceeded