i have few entries in a list and i want to take an average of all entries on monthly basis.
Create a site workflow which runs every month.
In the workflow -
1. Query list and get all values in a collection
2. Create an index variable i=0
3. Inside For-each action
4. use math operation to add A[i] and A[i+1]
5. increment i as i+1
6. outside the for-each action, use math operation to divide the output of for-each action by the total no of items
This is just a rough idea. I have not done this but I guess its do-able, a bit complicated though :-)
hi sumithra N
how we can take the total count of entries in the list.
After the first step.. U will get the query list of items and store it in a collection variable.. Then use Collection operation where u can get the total count of items in the collection.
Retrieving data ...