Hi guys,
Please!!, I need to solve a headache with formula fields, I need totalize each column column code on the report footer. Eeach formula field calculates the amount for each employee So, after I have grouped, I calculate the amount for each one, example: for @CALC22E I get the %value from {@RRSP22EPCODES} and calculate tha amount based in the payrate for each employee:
For the Code22E, the formula field is @CALC22E and it contains the formula:
({eeCompensate.PayRate}* Maximum({@RRSP22EPCODES},{eeEmployee.ChequeName}))/100;
The formula field for {@RRSP22EPCODES} is :
If {eePayCodes.Code} in ['22E'] Then {eePayCodes.Amount}
Depending of the code I get the value porcent from a table eePayCodes, and apply that value to calculate in @CALC22E
It works, but when I try to totalize SUM({@CALC22E}) and the remain codes for each column on the report footer, I have not choice to sum the formula field, and when I try to create a new formula to sum the msg is : "This field can not be sumarized"
Please I will apreciate any help!!!!
GonFer
Please!!, I need to solve a headache with formula fields, I need totalize each column column code on the report footer. Eeach formula field calculates the amount for each employee So, after I have grouped, I calculate the amount for each one, example: for @CALC22E I get the %value from {@RRSP22EPCODES} and calculate tha amount based in the payrate for each employee:
For the Code22E, the formula field is @CALC22E and it contains the formula:
({eeCompensate.PayRate}* Maximum({@RRSP22EPCODES},{eeEmployee.ChequeName}))/100;
The formula field for {@RRSP22EPCODES} is :
If {eePayCodes.Code} in ['22E'] Then {eePayCodes.Amount}
Depending of the code I get the value porcent from a table eePayCodes, and apply that value to calculate in @CALC22E
It works, but when I try to totalize SUM({@CALC22E}) and the remain codes for each column on the report footer, I have not choice to sum the formula field, and when I try to create a new formula to sum the msg is : "This field can not be sumarized"
Please I will apreciate any help!!!!
GonFer