Jump to content

portal count


krusader
 Share

This topic is 7701 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

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

Link to comment
Share on other sites

This topic is 7701 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.