One person suggested creating a SQL command in order to do the calculations before the data gets to the report.
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. 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.
WE CANNOT SUMMARIZE THIS FIELD WITH SUM BECAUSE HOW TO
In this example, you’ll see how to use the Average function. Later, you can change the setting, to use a different summary function. What I need Crystal Reports to do is take the sum of the duration. When you add a value to an Excel pivot table, it automatically summarizes the values by Sum or Count. 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. 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. This is a productivity report for our employees working at our business.
0 kommentar(er)
