Crystal Formula 2

[blairclw]

Can someone help me with formula? This is what my formula looks like now and it works......
{EmployeePG2_Job_Curr.HourlyAmount}>={EmployeePG2_Job_Curr.MaximumPayRate}

The formula will show me all employees that have maxed out but now I'm needing to show those employees that are $.50 to $.75 of maxing out and I'm just not up on all formulas. Can anyone help? Thanks!

 

[Turkbear]

Hi,
Very similar to the one you have:

{EmployeePG2_Job_Curr.HourlyAmount} in ({EmployeePG2_Job_Curr.MaximumPayRate} - .75) to
({EmployeePG2_Job_Curr.MaximumPayRate} - .50)

This will include all whose Hourly is in the range you specified - you can use it alone or OR it with your other one..









To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[blairclw]

OK I have another formula for someone.

I have a report that shows everyones birthday. I want to pull those birthdates by month. This is the table I would be pulling dates from and I'm not having luck with the formula. Thanks

{EmployeePos_Stat_Curr.BirthDate}

 

[TheBlondOne]

Have you tried

month({EmployeePos_Stat_Curr.BirthDate})

This will extract the month out of the birthday field.

Hope that helps

 

[blairclw]

I'm still not having any luck. Here is what I have in my report so far and when I try to add the formula to run birthdays by month it will not let me. I'm going up to REPORT - SELECTION FORMULA - REPORT

{EmployeePos_Stat_Curr.EmployeeStatus} <> "Terminated" and
not ({Organizations_Curr.Department} in ["8391 Medical Director TMC"]) and
not ({EmployeePos_Stat_Curr.JobCode} in ["042", "001", "003", "041"])

I would like to refresh report each month and type in the month I need and only pull those folks that have a birthday in that month. Sorry, not to good yet with formulas.

 

[Turkbear]

Hi,
Create a numeric parameter ( call it WhatMonth, maybe) and set default values of
1 through 12 - Add descriptions to show the Name of the month, if you like..Then, in your report selection formula add a test for it:

{EmployeePos_Stat_Curr.EmployeeStatus} <> "Terminated"
 and
not ({Organizations_Curr.Department} in ["8391 Medical Director TMC"])
 and
not ({EmployeePos_Stat_Curr.JobCode} in ["042", "001", "003", "041"])
 and
month({EmployeePos_Stat_Curr.BirthDate}) = {?WhatMonth}

Note: This assumes that {EmployeePos_Stat_Curr.BirthDate}
is actually a date Or DateTime field.

Hope it helps..






To Paraphrase:"The Help you get is proportional to the Help you give.."