Community
Showing results for 
Search instead for 
Do you mean 
Reply

ACT 2010 - Weighted Total does not calculate correctly on Opportunities screen

New Member
Posts: 8
Country: USA

ACT 2010 - Weighted Total does not calculate correctly on Opportunities screen

We are experiencing an odd problem with ACT (SQL-Multiuser).  The issue is that the “weighted total” calculation seems to be picking up a random “probability” percentage from somewhere.  Here is an example:

 

Should be:

Record 1: Total: 10,000; Probability: 95%, Weighted Total: 9,500

Record 2: Total: 10,000; Probability: 100%, Weighted Total: 10,000

Record 2: Total: 10,000; Probability: 90%, Weighted Total: 9,000

 

The first record starts out fine (when entering an opportunity – both in list and detail views).  Once you click the forward/back arrow the weighted calc’s get messed up.

 

What we are seeing:

Record 1:  Total: 10,000; Probability: 95%, Weighted Total: 16,285 (171%)

Record 2: Total: 10,000; Probability: 100%, Weighted Total: 5,800 (58%)

Record 2: Total: 10,000; Probability: 90%, Weighted Total: 6,821 (68%)

 

I have no idea what the Weighted Totals are using to come up with their numbers.

If you run an opportunity report, the Weighted Total numbers are fine.

If you click up/down on the probability it recalculates and works fine, but is replaced with a bad calc once you move off the record.  

 

Any ideas?