AnsweredAssumed Answered

Database failure when trying to create a report showing total opportunities by Probability %

Question asked by Philippa Grover on Nov 26, 2014
Latest reply on Nov 26, 2014 by Philippa Grover
I have written a Summation With Details report to extract all opportunities expecting to close in the next three months, and their corresponding probability percentages.

I have been able to create a total per month, which is great. But within that, I am getting a list of each opportunity and its corresponding probability percentage. What I need is a total by month, with a subtotal by probability.

For example:
November 2014
Total Opportunities at 20% = £1500
Total Opportunities at 35% = £3000
Total Opportunities at 50% = £4500
etc

Everytime I add "Opportunities > Probability (%)" to the Define Group By section of my report, I get an error stating "Database failure. Please refer to sugarcrm.log for details". I've looked at the log file, but I cannot make any sense of it.

Is it possible to total by Opportunity Probability Percentage?

Outcomes