Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 724
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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