Hi guys - I have the following set analysis, which are now working well thanks to Sunny!
=Count({<[WBR_Stat_Date] = {"$(=Date(Today()))"}>} [WBR_Event_Key]) - for calculating number of clients currently waiting
=Num(Median({$<[WBR_Stat_Date]={"$(=Date(Today(),'DD/MM/YYYY'))"}>} RangeSum([WBR_Event_Date], -[WBR_Clock_Reset_Date])),'#,###') - for calculating the median number of days clients have been waiting for, as of today's report date
I now have the following formula:
=Num(Count(if([WBR_Event_Date]-[WBR_Clock_Reset_Date]<=14,'0-14 days'))/
Count([WBR_Event_Key]),'#.#%')
This needs to calculate the % of clients who are seen within 14 days based on the [WBR_Event_Date]-[WBR_Clock_Reset_Date] part of the formula - but I need this to only show the % as of today's report date. So, again using the function today() to isolate my calculation to just today's report!
Appreciate all your help!
Rgds
