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
TuringTuring 

Calculate prorated figures based on the report starting and ending date / Passing Report date range to formulas

Is there a way in salesforce in which we can calculate prorated figures i.e. formula based on the starting and ending date of the report parameter.

Let say we have a contract with a client for 12 months Jan-15 to Dec 15 and we have defined the rate as monthly. How we can generate a report e.g. let say from Jul-15 to Sep-15 to gave us revenue for this duration.

something like Revenue= Rate * DateDiffMonth(ReportStartDate , ReportEndDate)


Appreciate any help. If this is possible or not.
 
Best Answer chosen by Turing
James LoghryJames Loghry
This isn't doable without some Visualforce or Visual flow kind of customization. Reason being is that you can't pass in dynamic parameters like you're talking into a formula field.  If you wanted a prorate that was always x days relative to today, or the close date or another field, then you could do that, but you can't do a dynamic range.

All Answers

James LoghryJames Loghry
This isn't doable without some Visualforce or Visual flow kind of customization. Reason being is that you can't pass in dynamic parameters like you're talking into a formula field.  If you wanted a prorate that was always x days relative to today, or the close date or another field, then you could do that, but you can't do a dynamic range.
This was selected as the best answer
TuringTuring
This make sense. Thank you James.