Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Duplicate:
Hi
Please provide the specific scenario to get the exact result for above issue
thanks
Hi
thanks for the reply !!
i need hr_month should get data only betweeen 1 and max(hr_month)
Thanks
hr_month = {'>= 1 < $(=max(hr_month))'}
or
hr_month = {'>= 1 < $(=max(num(hr_month)))'}
try this condition in your current one
HR_MONTH ={">=$(=min(HR_MONTH))<=$(=max(HR_MONTH))"}
Regards,
Nirav Bhimani
Sum({$<Year = {$(=max(Year))}, MTDYTD = {'MTD'}, HR_MONTH = {$(=max(HR_MONTH))},
HR_Month1 = {">=1<= max(HR_MONTH)"}>} HR01_ACTIVEEMPLOYEE + HR01_TEMPRYEMPLOYEE*Emp_Value)
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