giorgiosilvio.patalani_1

In Crystal i can specify the group level of the sum Example sum({@TOT},{Comando.CodContract}) / sum({@TOT},{Comando.CodCity}) * 100 <- total people with X contrct -> <-- total people in Y city -> Group City Sub Group Contract <<<<<< This comment was blocked and unpublished because Project Honeypot indicates it came from a suspicious IP address.

In each row of (office) I have to calculate the percentage of people in the office with respect the total of the contract . This is easy with the percent tool. But in the row of the total of contract I have to show the percentage of people with that contract with respect the total of the people in that city. <<<<<< This comment was blocked and unpublished because Project Honeypot indicates it came from a suspicious IP address.

I Have to do a report like this Company Com1City Ct1Contract Co1 Office Off1 Male 5 Female 5 Tot 10 % 33,33 Office Off2 Male 10 Female 10 Tot 20 % 66,66 Total Co1 Male 15 Female 15 Tot 30 % 42,86 Contract Co2 Office Off1 Male 10 Female 10 Tot 20 % 50,00 Office Off2 Male 10 Female 10 Tot 20 % 50,00 Total Co2 Male 20 Female 20 Tot 40 % 57,14Total Ct1 Male 35 Female 35 Tot 70 % 100,00 Total Com 1 Male 35 Female 35 Tot 70 % 100,00 Grand total Male 35 Female 35 Tot 70 % 100,00 I tried with $V{TotCtr}.equals( new BigDecimal(0) ) ? new BigDecimal(0) : $F{TOT}.multiply(new BigDecimal(100)).divide($V{TotCtr},2,java.math.RoundingMode.HALF_UP) That TotCtr is the variable with the total of the contract and TOT is the total po the people in the office. I put this in a text field with the time of calculation (tempo di processione) = Auto ,with no luck. Thanks.