September 21, 200025 yr 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
September 21, 200025 yr 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 =-=-=-=-=-=-=-=-=-=-=-=-=
Create an account or sign in to comment