Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to create an expression that says - if the field [Projected Close Date] is 370 days or more in the future, sum the combined_amount. Here is what I've written, but it isn't correct. What am I doing wrong?
Sum({<Date#([Projected Close Date])>={Date#(Today())+370}>}Combined_Amount)
Hi @dmarxer0414
How about like this?
Sum({$<Date#( [Projected Close Date])= {">=$(=Date#(Today()+370)))"}>} Combined_Amount)
Hi @dmarxer0414
How about like this?
Sum({$<Date#( [Projected Close Date])= {">=$(=Date#(Today()+370)))"}>} Combined_Amount)
Thank you!! This worked (I needed the syntax inside the second brackets.