Multiple selection on enter in a sheet

[danosoft]

Hi i need to do a multiple selection of my months when i enter in my sheet.

for now i put this expression in the action:

=num(month(now())-2,'00')

but this only select my month-2 (example 08)

I need to select not only the 08 but all months beofre 08, so: 08,07,06,....01

my field name is: MESE_COMP

what kind of expression i need to put in the action for make that selection?

thanks

[tresesco]

Try like:

='<='&num(month(now())-2,'00')

[danosoft]

Hi, thanks this work for the selection of my months, but in my expression in my text box it do an error:

Error: Error in expression: ')' expeded

my expression is this (if i choose months manually all work good)

='Performance Mese' & chr(10) &

if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='01','Gennaio',
if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='02','Febbraio',
if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='03','Marzo',
if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='04','Aprile',
if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='05','Maggio',
if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='06','Giugno',
if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='07','Luglio',
if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='08','Agosto',
if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='09','Settembre',
if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='10','Ottobre',
if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='11','Novembre',
if(num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00')='12','Dicembre',''))))))))))) )

and i have in my chart a set analisys like this and in your way not work:

num(Sum({<MESE_COMPETENZA={"$(=num(rangemax($(=GetFieldSelections(MESE_COMPETENZA, ',', 100))),'00'))"}>} CONSUMO_SMC),'#.##0;(#.##0);-'),