08-22-2008 06:20 AM
Is ther a way that you can write a field for a report that multiplies two other fields.
I'm changing the pipeline report to suit our needs and wanted to get estimated fees. To do so I was going to use one of the user fields as a fee % times the price field to get annual fee estimates.
Thanks for the help
08-22-2008 11:06 AM
08-25-2008 07:35 AM
How do you know what the field # is?
I see the following in the edit screen Format(Sum(Field14), "Currency") so I can figure out what Field 14 is.
Then on the edit reports screen I see
If Field10 = Null Then
Custom5.Text = ""
So how do I know what field number the rest are? Also how do I know what number the custom field is
Also, would the script run in the edit section? if so I would supect it to look something like this:
If Field ? = Null Then
Custom?.Text = ""
Custom?.Text = Field?*Field14
08-25-2008 12:02 PM
You can find the actual field name by right clicking on the field and choosing properties.
Check you private messages.
10-09-2008 11:40 AM
I would like a vb script to filter the type of history in a report to only be "Contact Deleted", to keep a record of deleted contacts. I think it would be something to do with the variable "contains"? for the "result" field?
10-09-2008 01:30 PM
02-12-2009 09:47 AM
Even though there is no official filtering in Act! reports, is there a 'suppress' option? I.e., could you look at the text field that contains some data, do an if then else with a suppress. See the following idea:
If Var1 = "xyz" then
Var2 = "true"
I have the same problems as some folks above. I created a custom history report with times included. I want to filter out all detail that is zero time. If there were a suppress function for the data, then I could do that.
02-12-2009 10:03 AM