10-12-2011 05:17 PM
I am trying to define some custom fields in a report but cannot find a listing anywhere of allowed syntax in custom fields.
For example I have a report where I am trying to return the count of each type of answer to a specific field, something like:
if([C:ETSA Status 0]="8 Approved",1)
but this and many variants I've tried don't seem to work.
Any suggestions on where I might find a syntax guide or answer to this question would be appreciated.
10-12-2011 08:41 PM
The ACT! reports use Visual Basic script programming for that.
There is a third party book with comprehensive training information on the ACT! reports, here is the link.