Hi,
You can use DCOUNT to count the number of multivalued opened of a
particular multivalued field.
for example TOT.VAL = DCOUNT(TURNOVER.DEBIT,VM) will give u the total
numbers of multivalued opened for the field TURNOVER>DEBIT.
You can also use SUM(TURNOVER.DEBIT) to get the sum of all the values in all
opened multivalued fields of TURNOVER.DEBIT
Regards,
Imran
On Wed, May 20, 2009 at 8:50 PM, [email protected] <[email protected]>wrote:
>
> hello
> im working on a report and would need a routine to loop through a set
> of multi value fields, count and add up the fields and store the
> values in a dynamic array. say for example i need to add up the
> TURNOVER.DEBIT values for a month based on an ID in the table
> ACCT.ACTIVITY
> i am relatively new to jbase and would need some ideas on how to go
> about it.
>
> thanx in advance
>
> Paul
>
> >
>
--
Imran Khan
T24 Technical Consultant
+92 334 3545114
--~--~---------~--~----~------------~-------~--~----~
Please read the posting guidelines at:
http://groups.google.com/group/jBASE/web/Posting%20Guidelines
IMPORTANT: Type T24: at the start of the subject line for questions specific to
Globus/T24
To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
-~----------~----~----~----~------~----~------~--~---
