How to add a new field in Crystal Reports that doesn't exist in a table

Claude Constantinescu
Claude Constantinescu used Ask the Experts™
on
Hello all, I have a Crystal Report that I want to modify, I need to insert a new field which doesn't exist in the tables but I want to be a calculation of (100 - a current field), can you please guide me how I can do this? I already spent 2 hours and I cannot figure it out

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Professor of MIS at Penn State Erie and Owner, Millet Software
Commented:
Create a formula:

Open the Field Explorer (View > Field Explorer)
 Right-click on Formula Fields. Select New. Enter a name for the formula. Click OK.
Use the Formula Editor to write the formula.
Thank you very much, it worked! :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial