Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How would I write an expression to only show data from current date forward on field 'Path_Start_Date'?
HI
Try like this
=sum({<Date = {'>=$(=Min(Date))<=$(=Today())'}>}Sales)
Calculate values From today to minimum date as per selection..
Hope that helps
Another possibility is adding a flag to your calendar:
if(Path_Start_Date>=today(),'Y') as Current_Date_Forward,
And doing this:
count({<Current_Date_Forward={'Y'}>} Bookings)
It should be slightly faster to process, and may be easier for some people to understand.