Adding a Percentage Comparison Formula in Crystal Reports
Posted on 2008-10-17
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