Count function

This article describes the formula syntax and usage of the Count function in JungleDocs.


Description

Returns the total number of items in a Sharepoint list.

Syntax

Count(recordSet)

The Count function syntax has the following arguments:

  • RecordSet   Required. Any function that returns a list of items (e.g., GetView). 

Remarks

If the library where the final document will be generated is not at the same subsite as the list of data, you need to provide a path to that list in the formula. If the library and the list are on the same subsite, providing the list name is sufficient. For example, if you want to count all items in the ProductA view of the Licences list which is on the Sales subsite, your function would be:

Count(Getview("/Sales/Lists/Licenses/"; "ProductA"))

Example

Count(GetView("Licences"; "All"))

Returns the total number of items in the All view of the Licences list.

Count(Getview("/Sales/Lists/Licenses/"; "ProductA"))*100/Count(GetView("/Sales/Lists/Licenses/"; "AllItems"))

Returns the total number of items in the ProductA view as a percentage value.

Round(Count(Getview("/Sales/Lists/Licenses/"; "ProductA"))*100/Count(GetView("/Sales/Lists/Licenses/"; "AllItems")); 2)

Returns the total number of items in the ProductA view as a percentage value and rounds the value to 2.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us