SBSMedicalTech
Programmer
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 %
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 %