Hi

 i want to be able to count the rows in a portal which meet a certain criteria.

It is a portal of tasks assigned to an employee. One of the fields in the portal are the tasks status i.e. Overdue , Due , Outstanding or completed.

I want to display on the opening page the amount of tasks that are due .

i managed to get the total of all tasks by using the foundcount function but unable to split it down this function down further by adding another rule.

i would appreciate ones help, thanks.

 

Edited June 8, 20169 yr by Smiley

Do your report in the Related File,

Thanks  for your response , could be i wasn`t clear ,

What i am having an issue is with scripting the calculation

28 minutes ago, Smiley said:

i managed to get the total of all tasks by using the foundcount function but unable to split it down this function down further by adding another rule.

would you so kindly be able to guide me on that

Here's one way:

ValueCount ( FilterValues ( List ( Tasks::Status ) ; "Due" ) )

Another way is to use a summary field (defined in the Tasks table) and place it inside a filtered one-row portal.

for some reason 

30 minutes ago, comment said:

ValueCount ( FilterValues ( List ( Tasks::Status ) ; "Due" ) )

doesn`t seem to work , it gives me a value of 1 when it is not , any idea where i am going wrong

i changed 

30 minutes ago, comment said:

( Tasks::Status )

for my table and field where "Due" displays

 

1 minute ago, Smiley said:

any idea where i am going wrong

No, of course not.