Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a selectable dimension called CalanderMonth that I am able to select return information for the current month of shifts that have not been allocated. This works fine, but I would like to be able to return the following months information.
I have a VisitStartDate field that I am using for the date element, a new variable which works out the following month start and one that works out the end of the month vNextCalendarMonthStart and vNextCalendarMonthEnd respectively.
Currently I have the formula =num(Sum({<VisitPayStatus = {'Incomplete*'}}VisitCounter) ,'#,###.') to pull the data for this month, but I need to expand it to only return information on the following month. Any help would be great. Thank you.
Hi @JamesMF82 ,
Please try the below expression.
num(Sum({<VisitPayStatus = {'Incomplete*'},
VisitStartDate=("='>=' & Date(vNextCalendarMonthStart, 'MM/DD/YYYY') & '<=' & Date(vNextCalendarMonthEnd, 'MM/DD/YYYY')")
>}VisitCounter) ,'#,###.')