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
ShivaniShivani 

Reports and Dashboard

HI,

 

Is there any way to show Closed Opportunity in diifferent week's for a particular time period With Amount, in Reports?

Please help.

 

Thanks,

Shivani.

SrikanthKuruvaSrikanthKuruva

you can create a formula in the report (Add formula) and give the formula as 

CEILING(( CloseDate - DATE(2011 , 01, 01))/7)+1   --- this formula will return you the week number of the week in which the opportunity was closed.

or you can create a custom formula field with the same above formula and show that in reports.

 

remember this formula will work for only those opportunities closed this year(2011).

 

let me know if you have any issues