I'm new to Crystal Reports....
I want to create a report those the min, midpoint and max salary of every position.
I use the position table and salary table. Our salary table is set up with a each Grade having steps 1-16 with a corresponding rate. Mininum would be step 1, midpoint would be step 8 and max would be step 16.
I want the report to look like this:
Position Number Position Name Grade Step 1 Step 8 Step 16
555-55555 Secretary 12 10.01 12.01 13.01
I can get the first three columns ok but I can't seem to get the rates Ok. I tried using a formula but I am getting TRUE/FALSE answers instead of the actual rates.
Can anybody point me in the right direction?