Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with a Crystal Report to determine Percentage change between formula and static value 1

Status
Not open for further replies.

SBSMedicalTech

Programmer
Apr 16, 2012
21
US
I need help calculating the percentage difference between two fields.

In my report, I have the following formula fields set up:

Est1 Actual %
Est2 Actual %
Est3 Actual %
Est4 Actual %
Est5 Actual %

I also have 5 static percentages for each of these I need to get a percentage difference for:

1 %
20 %
59 %
18 %
2 %

In total, I need 5 new formula fields to determine the percentage difference between a formula field and a static value:

Percent diff between "Est1 Actual %" and "1 %"
Percent diff between "Est2 Actual %" and "20 %"
Percent diff between "Est3 Actual %" and "59 %"
Percent diff between "Est4 Actual %" and "18 %"
Percent diff between "Est5 Actual %" and "2 %
 
Just create 5 more formula

eg
@Est1 Diff
1- {@Est1 Actual %}

Repeat for others

Ian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top