Feed

Based on the image you shared you are to signup. Use the new link i shared

Hi @HARDIK K

If you change your browser or clear caches are not helping you in this regard if you are facing same problem which I faced it too then you check your report or otherwise you need to delete your report and fresh try it.  

I hope that you create your report as usual as said in the project then you would not 

run the report as your first attempt

 you need to save the report and check the challenge that you could face any error or not then please proceed and check the challenge I hope  you will be successfully complete the challenge.  

Thanks and Regards 

Palash

Hi @Terry Cole

-- I am interested in your case use, using the Volunteer4SF to track class attendance -- I think it would work for us as well. Are you still using that? (The link above is no longer active.) 

Thanks

Hi @Anne Fleetwood

To filter for the current month and same month last year:

1. Set the mandatory Date filter to 'Current and Previous Calendar Year' (or fiscal year)
2. Add an optional Date filter set to "equals This Month"
3. Add a second option Date filter set to "equals 12 Months Ago"
4. Add Filter Logic to the report and set it as "1 OR 2"

Be aware that this will compare the current Month to date against the full month last year.  If you want to compare the current MTD against MTD last year, you need to add a third date filter of "Less or Equal 364 Days Ago" and change the filter logic to "1 OR (2 AND 3)."

The most basic solution for a YoY% calculation is a Summary formula using PREVGROUPVAL().  Group rows by [Assigned] and group columns by [Date], then set the Date field to group by Calendar Month.  Create a Summary Formula called 'YoY%' using the formula:

IF(
    /* Retun null if last year is null or zero */
    BLANKVALUE(PREVGROUPVAL(RowCount, COMPLETED_DATE_TIME), 0) = 0,
    null,
    (RowCount - PREVGROUPVAL(RowCount, COMPLETED_DATE_TIME)) / PREVGROUPVAL(RowCount, COMPLETED_DATE_TIME)
)

Change the Summary Formula's display settings to 'Selected Groups' and set Row Group to [Assigned] and [Column Group] to date. 

The downside of this method is that it can only show the YoY% for each Assignee separately.  If you want to know the YoY% change across all Assignees you'll need to create a second Summary formula and change the Row Group display setting to 'Grand Total.'  You'll also get blank YoY% rows in your last year and Grand Total columns (see screenshot below). 

Hi, 

Same issue.  

I have just created playground as suggested in the module and play with this org. 

Does somebody know how to fix this? 

you asked "the screenshot for ListOpertaion 33 in the Pricing Procedure" - where to find this? RLM is so confusing 

Dmitry