stefone
asked on
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
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
That is a percentage not a difference.
I think you really need
(A-B)/B
mlmcc
I think you really need
(A-B)/B
mlmcc
Opps.. yeah you are right.. but my head was in the right direction.. hehehe.
Also you should check if B is 0 to avoid a 0 divide error
mlmcc
mlmcc
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
A = 0
B = 2
if isnull(A) or A= 0 then 0
else (A/B)*100
A and B represent your fields.