krusader Posted September 21, 2000 Share Posted September 21, 2000 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 More sharing options...
Kurt Knippel Posted September 21, 2000 Share Posted September 21, 2000 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 More sharing options...
Recommended Posts
This topic is 8611 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 accountSign in
Already have an account? Sign in here.
Sign In Now