Need a sample of code for IF/ELSE stament whe Selecting two or more month or year?

[#1]

Can someone help me find a code for that?

[#2]

???????

[awqvuserneo]

Hi Lahib,

Are you looking for this?

If(getselectedcount([MonthField])>2 OR getselectedcount([YearField])>2, do X, do Y) ?

Best regards,

-A

[Anonymous]

Exactly,  what  do you want  do?

[#5]

can this be used part of the set analysis?

If (getselectedcount([MonthField])>=2 OR getselectedcount([YearField])>=2,

SUM (X),

else

SUM (Y)

[robert_mika]

I assume you are looking for VBA?

If what?Then

Else what?

[awqvuserneo]

Depends...What your set analysis look like?

[#8]

I am looking for Set Analysis statement like this:

//if more than one month is selected then we need to exclude  [Unit of Measure] -= {'BBM'}

If ((getselectedcount([Month])>=2 OR getselectedcount([Year])>=2),

=sum({$<[Location] -= {'790','791','793','794','795','796','797','798','799','R12086','R14030','R14031'},[APP] -= {'CE'}, [Unit of Measure] -= {'BBM'} >} AMDOL),

//else one month is selecte then

=sum({$<[Location] -= {'790','791','793','794','795','796','797','798','799'},[APP] -= {'CE'} >} AMDOL)

this one is not working for me. I appreciate your help

[#9]

I am looking for Set Analysis statement like this:

//if more than one month is selected then we need to exclude  [Unit of Measure] -= {'BBM'}

If ((getselectedcount([Month])>=2 OR getselectedcount([Year])>=2),

=sum({$<[Location] -= {'790','791','793','794','795','796','797','798','799','R12086','R14030','R14031'},[APP] -= {'CE'}, [Unit of Measure] -= {'BBM'} >} AMDOL),

//else one month is selecte then

=sum({$<[Location] -= {'790','791','793','794','795','796','797','798','799'},[APP] -= {'CE'} >} AMDOL)

this one is not working for me. I appreciate your help

[#10]

=If ((getselectedcount([Month])>=2 OR getselectedcount([Year])>=2),

sum({$<[Location] -= {'790','791','793','794','795','796','797','798','799','R12086','R14030','R14031'},[APP] -= {'CE'}, [Unit of Measure] -= {'BBM'} >} AMDOL),

sum({$<[Location] -= {'790','791','793','794','795','796','797','798','799'},[APP] -= {'CE'} >} AMDOL))