Set analysis help

[Anonymous]

HI i need help on set analysis in the below expression.

Sum({$<Year={$(=max(Year))},MTDYTD = {'MTD'},HR_MONTH ={$(=max(HR_MONTH))},HR_Month1=>} HR01_ACTIVEEMPLOYEE + HR01_TEMPRYEMPLOYEE*Emp_Value).

For HR_MONTH i want to write

HR_MONTH Betwen 1 and MAX(HR_MONTH)

Thanks

[robert_mika]

Duplicate:

set expression help

[#3]

Hi

Please provide the specific scenario to get the exact result for above issue

thanks

[Anonymous]

Hi

thanks for the reply !!

i need hr_month should get data only betweeen 1 and max(hr_month)

Thanks

[vvvvvvizard]

hr_month = {'>= 1 < $(=max(hr_month))'}

or

hr_month = {'>= 1 < $(=max(num(hr_month)))'}

[nirav_bhimani]

try this condition in your current one

HR_MONTH ={">=$(=min(HR_MONTH))<=$(=max(HR_MONTH))"}

Regards,

Nirav Bhimani

[#7]

Sum({$<Year = {$(=max(Year))}, MTDYTD = {'MTD'}, HR_MONTH = {$(=max(HR_MONTH))},

HR_Month1 = {">=1<= max(HR_MONTH)"}>} HR01_ACTIVEEMPLOYEE + HR01_TEMPRYEMPLOYEE*Emp_Value)

[#8]

Hi rgv,

can HR_MONTH actually be less than 1? From the sound of it I would think not so all you would need is a less than/equal to max. Keeps the expression simpler

HR_MONTH ={"<=$(=max(HR_MONTH))"}

hope that helps

Joe