Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Cumulative % Increase Post Reply Post New Topic
Author Message
Matt12391
Newbie
Newbie


Joined: 26 Nov 2012
Location: United Kingdom
Online Status: Offline
Posts: 4
Quote Matt12391 Replybullet Topic: Cumulative % Increase
    Posted: 29 Nov 2012 at 12:43am
I currenlty have something ike this;
If {Career_History_Custom.Grade}= "6" then 56000 else
If {Career_History_Custom.Grade}= "8" then ((56000/100)*111)else
If {Career_History_Custom.Grade}= "9" then ((62160/100)*111)else
If {Career_History_Custom.Grade}= "11" then ((68997.6/100)*111)else
If {Career_History_Custom.Grade}= "12" then ((76587.34/100)*111)else
If {Career_History_Custom.Grade}= "13a" then ((85011.95/100)*111)
 
Which works out a cumulative increase of 11% on the figure given. But it is fairly useless as I have to input the 11% increase figure. Can i save a result from the above calculation in the forumla to be inserted later on? How can I get an 11% increase cumulatively by only inputiing the first number "56000"? Thanks
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 29 Nov 2012 at 12:13pm
56000 * 1.11 ^ x
where x equals a value from 0 - 5 depending on grade
grade
6, x = 0
8, x = 1
9, x = 2
11, x = 3
12, x = 4
13a, x = 5
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.