Variables in Expressions

[Anonymous]

Hello,

I am looking to write an expression to sum totals of accounts with an opened date equal to or great than a specified time period. 

assuming the period is December 31, 2014 to December 31, 2015

example:

=sum({<open_dt={$(vLastPeriod)}

     ,type = {'L','C'}

     >} sales)

Can someone help with my expression to include greater than or equal to.  The following did not work:

=sum({<open_dt={>=$(vLastPeriod)}

     ,type = {'L','C'}

     >} sales)

[sunny_talwar · Accepted solution]

Try one of these:

=Sum({<open_dt={">=$(vLastPeriod)"}, type = {'L','C'}>} sales)

or

=Sum({<open_dt={"$(='>=' & vLastPeriod)"}, type = {'L','C'}>} sales)

[Anonymous]

Thank you - that worked!

[sunny_talwar]

Great. Please close the thread by marking correct answer if you got what you were looking for