• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 725
  • Last Modified:

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
0
John-Michael_Davis
Asked:
John-Michael_Davis
  • 2
  • 2
1 Solution
 
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
 
mlmccCommented:
Look at the formulas i wrote in this copy of your report.

mlmcc Pricing-Mailer-11-11-10rev.rpt
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now