Solved

Formula Help for Crystal Report

Posted on 2014-04-19
3
303 Views
Last Modified: 2014-05-11
I need some assistance trying to come up with a formula in crystal.  Attached is a picture that I think should give you what you need, along with the below txt.

Currently 5 (ItemDemand.ReOrdQTY) is the correct answer for "# of packages to Reorder to Max", although there are rare times when the answer needs to change. When 1 is greater than 4 then 5 should be replaced by 4-2+3 (Please see picture for table information)
tables.jpg
0
Comment
Question by:Mcottuli
  • 2
3 Comments
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Try this

You need to replace the fields with your field names

If ({Field1} > {Field4}) then
    {Field4} - {Field2} + {Field3}
Else
    {Field5}

mlmcc
0
 
LVL 1

Author Comment

by:Mcottuli
Comment Utility
i tried that but the field are actually Sum of (field) in a couple cases. should it matter ?
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
Comment Utility
So long as you are in the same scope it shouldn't matted

mlmcc
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now