function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
LJHOWELJHOWE 

Formula to calculate revenue goals by percentage, number of days and custom object name.

I have a custom object called Production Summary.

 

I want to calculate the current expected Life Sales by the Production Summary name.

 

I've got the math calculation, i.e. "Agency_Life_Goal*20/100/90*Number_of_days"

 

Now I just need to know how to tell it If "Production_Summary_Name -= "January 2010 Production" I want the formula above, February 2010 Production, I want the formula above, March 2010 Production, I want the formula above.

 

In the Second quarter, the formula changes to 40/100/180*Number of days.

 

Any Suggestions? 

marco_29marco_29

You can use the function Case

 

 

Case (Production_Summary_Name,

"January 2010 Production", Agency_Life_Goal*20/100/90*Number_of_days,

"February 2010 Production", Agency_Life_Goal*20/100/90*Number_of_days,

"March 2010 Production", Agency_Life_Goal*20/100/90*Number_of_days,

"April 2010 Production",Agency_Life_Goal*40/100/180*Number_of_days,

...

)

 

Marco