variable time range

[#1]

Hello!

I need to include in a analisys set, a variable range running from 2010 until the term is applied (Not today ())

That is, if I make a calculation for 2013 that would range from 2010 to 2013 and if it did in 2016 would range from 2010 to 2016

count ({<SET ANALISYS>} if (Reactivation = 'YES', NumeroDeAfiliado))

Thank you very much!!

[sunny_talwar]

If you make calculation? How do you make calculations here? Do you mean make selection in year field?

May be this:

Count({<Year = {'>=2010<=$(=Max(Year))'}, Reactivation = {'YES'}>} NumeroDeAfiliado)

[vinieme12 · Accepted solution]

count ({<YEAR = {">=2010&<=$(vYearSelection)"}>} if (Reactivation = 'YES', NumeroDeAfiliado))

where variable

vYearSelection = getfieldselection(YEARFIELD)

[#4]

hi! Thank you Vineeth!

As I create "vYearSelection" variable in the script?

don`t take that as a function.

[sunny_talwar]

You want to create it in script?

[#6]

Yes, just the variable 'vYearSelection'

[sunny_talwar]

Then how will this be dynamic? I am missing something here?

What did you mean here:

"if I make a calculation for 2013 that would range from 2010 to 2013 and if it did in 2016 would range from 2010 to 2016"

[vinieme12]

SET vYearSelection = getfieldselections(YEARFIELD);