Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression to only show current date forward

How would I write an expression to only show data from current date forward on field 'Path_Start_Date'?

2 Replies
MayilVahanan

HI

Try like this

=sum({<Date = {'>=$(=Min(Date))<=$(=Today())'}>}Sales)

Calculate values From today to minimum date as per selection..

Hope that helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
johnw
Champion III
Champion III

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.