Adding Constants to Cross Tab Totals

[dhgrrg]

I have a payroll cross-tab report that summarizes houly wages by PayGroup.

I want to add constant per day for Salaried Employees
PayGroups: Salary/ Sales=$150,Admin=$100,Service=$75 ,Guest=$125.

Can I write a formula that adds in the salaried totals sample summary of hourly dollars are listed below)
Hourly / Sales:$1000, Admin= $600, Service=$750, Guest $0

Group Totals would show as follows:
Sales=$1150,Admin=$700,Service=$825 ,Guest=$125.

Grand total would be $2800

Thanks in advance





Thanks in advance

 

[synapsevampire]

Please post example data, and what the cross-tab will look like.

How do we know which type of employee each is?

Cross-tabs don't allow for much customization in terms of formulas only at certain levels.

-k

 

[dhgrrg]

I don't need details of employees. Only one group "MCode: Aaa,Bbb,Ccc, etc". To the sums below I would add $100 each day for Aaa; $250 each day to Bbb; $0 each day Bar; etc. Same amount every day.

MCODE 10/4/04 10/5/04 10/6/04 10/7/04 Total
Aaa $168.64 $169.50 $172.32 $164.32 $674.78
Bbb $165.25 $108.81 $101.45 $162.18 $537.69
Ccc $100.27 $84.32 $117.86 $123.73 $426.19
Ddd $408.50 $369.68 $478.97 $564.46 $1,821.60
Eee $541.46 $520.70 $460.62 $515.76 $2,038.54
Fff $319.49 $301.08 $299.22 $285.60 $1,205.39
Ggg $185.33 $525.99 $693.26 $746.58 $2,151.15
Total xxxxxx xxxxxxx xxxxxx xxxxxx xxxxxxx

I don't have to have "RH Column Total" or "Bottom Row Total"

Thanks Again

 

[synapsevampire]

I think that you want to use a formula which adds $100 in addition to the sum formula, hard to say though, try posting tech info:

Crystal version
Database/connectivity
Example data
Expected output

-k

 

[dhgrrg]

That is correct. I want to add $100 to sum of Aaa; $250 to sum of Bbb. $0 to sum of Ccc. Using Crystal Version 9

MCODE 10/4/04 10/5/04 10/6/04 10/7/04
Aaa $168.64 $169.50 $172.32 $164.32

with $100 salary addin
Aaa $268.64 $269.50 $272.32 $264.32

Bbb $165.25 $108.81 $101.45 $162.18 $537.69

with $250 salary addin
Bbb $415.25 $368.81 $351.45 $412.18


Ccc $100.27 $84.32 $117.86 $123.73 $426.19

with $0 salary add in
Ccc $100.27 $84.32 $117.86 $123.73 $426.19