Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1349
  • Last Modified:

Adding a Percentage Comparison Formula in Crystal Reports

Hi

I am very new to Crystal Reports especially when it comes to adding numerous different formulas and conditions.  
I have a report I have made which works in everyway it should including most formula except the percentage ones.  I need to find the percentage difference from 2 values.  I have created4 if, then else formula and 2 sum formula to add relevant values to gether.  These are fine.  My database contains no numerical values only string text and dates.  I created If, then else formula to add different statuses together and sum to add each of these together.  I need to create a percentage formula to caluclat edifference between the 2 SUM values but this is not working.  I tried insert summary and selecting option for percentage difference but this only gave me option to pick one field which is not the one I need.

Any ideas or pointing me in right direction

Many Thanks
0
stefone
Asked:
stefone
  • 3
  • 2
1 Solution
 
wykabryanCommented:
well to find the % diff, it is a simple formula.
A = 0
B = 2

if isnull(A) or A= 0 then 0
else (A/B)*100

A and B represent your fields.
0
 
mlmccCommented:
That is a percentage not a difference.

I think you really need

(A-B)/B

mlmcc
0
 
wykabryanCommented:
Opps.. yeah you are right.. but my head was in the right direction.. hehehe.
0
Industry Leaders: 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!

 
mlmccCommented:
Also you should check if B is 0 to avoid a 0 divide error

mlmcc
0
 
stefoneAuthor Commented:
Hi

Thanks for comments.  I am almost there but as per you comment mlmcc I do have nil values for field b.  creating the if function ho wdo i incorporate the second field b = 0 into the formula

Thanks
0
 
mlmccCommented:
Somethin glike

If B = 0 then
    0
else
   (A-B)/B

mlmcc
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

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