portal count

[krusader]

I am counting the records that are displayed in a portal and want the results to be displayed in a field automatically

Author is the field that I am using to count portal records

I have a Calculation field with the calculation "Count(portal::Author)"

it works fine...BUT when there are no records in the portal it won't display the 0 in the calculation field...I need it to display the 0...

THANKS

[Kurt Knippel]

quote:

---

Originally posted by krusader:

I am counting the records that are displayed in a portal and want the results to be displayed in a field automatically

Author is the field that I am using to count portal records

I have a Calculation field with the calculation "Count(portal::Author)"

it works fine...BUT when there are no records in the portal it won't display the 0 in the calculation field...I need it to display the 0...

---

Use: If ( IsValid (portal::Author), Count(portal::Author), 0).

This way it will return a ZERO if it is not able to count the non-existant records.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=