we cannot summarize this field with sum because

#We cannot summarize this field with sum because code

As a result, your numbers as Text will be converted into the real numbers and your existing Sum formula will return the correct output. One person suggested creating a SQL command in order to do the calculations before the data gets to the report. 2) Click on Text to Columns and click on Finish in the next window which pops up which is Text to Columns wizard window. Is there a way to create a custom function to accomplish what I am trying to get here? Or is it even simpler than that?

Then I can summarize What am I missing? It has to be something simple, but I'm just not seeing it.

#We cannot summarize this field with sum because code

Here's my code for the duration: local numbervar num1 However, if the service code is, say, '1000', it must first divide the duration by 3 before summing it. What I need Crystal Reports to do is take the sum of the duration. The service code field is also a string field, and it sometimes does contain characters and numbers. The duration field is initially a STRING field from the database, even though it only gives number data, so I change it to a numberVar. 'We can't summarize this field with Max because it's not a supported calculation for text data types'. So, I have two fields in this formula, a service code field and a duration field. We determine what service they gave by service codes. They charge each client within the group, even though they are only giving, for example, one hour of service, they can bill for 10 hours if there are 10 people in the group. Some of our employees offer group sessions. We determine their productivity based on the duration of the visits with clients. As other animals watch the scene from outside the window, they cannot tell the pigs.

This is a productivity report for our employees working at our business. Get free homework help on George Orwells Animal Farm: book summary.