How do I achieve to display monthly revenue between start date and end date in a report?
For example: Monthly Revenue amount = 60000
Start date - 01/01/21 = January 2021
End Date - 12/01/21 = December 2021
I want to disply 60000 for every month Jan 21 to December 21.
Thanks in advance
Lakshmi
5 risposte
PS. Why not just create a custom Formula(Date) field instead of the Formula(Text) field instead of doing this
I have created a Formula Field (Month_to_Date) =
CASE(MONTH(Date__c),
1, "January",
2, "February",
3, "March",
4, "April",
5, "May",
6, "June",
7, "July",
8, "August",
9, "September",
10, "October",
11, "November",
12, "December",
"None")
