Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Try one of these:
=Sum({<open_dt={">=$(vLastPeriod)"}, type = {'L','C'}>} sales)
or
=Sum({<open_dt={"$(='>=' & vLastPeriod)"}, type = {'L','C'}>} sales)
Try one of these:
=Sum({<open_dt={">=$(vLastPeriod)"}, type = {'L','C'}>} sales)
or
=Sum({<open_dt={"$(='>=' & vLastPeriod)"}, type = {'L','C'}>} sales)
Thank you - that worked!
Great. Please close the thread by marking correct answer if you got what you were looking for