Sum (minimum value) of formula with shared variable

I have a report that is fulling a price value from a subreport that needs to be used in calulation to determine the final price of an item. then based on the three possible sets of calculations chooses the lowest value. This was working great until I introduced the shared variable into the calculation process and now I get a non summable field issue even the the @total formula is returning a result.
Pricing-Mailer-11-11-10.rpt
LVL 1
John-Michael_DavisAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:
Look at the formulas i wrote in this copy of your report.

mlmcc Pricing-Mailer-11-11-10rev.rpt
0
 
mlmccCommented:
The problem is summary functions are run in an early pass through the report while the shared variables and subreports are evaluated in the last pass (Printing Record pass)  

You will have to do the smmary manually using a formula

mlmcc
0
 
John-Michael_DavisAuthor Commented:
Thank you mlmcc, that worked perfectly
0
 
John-Michael_DavisAuthor Commented:
Having the formulas added to the report made it very clear how the logic would fit in my situation.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.