Problem with @Count and @DbColumn

HCL Domino Domino Forum
1

Hello everyone. Please review the following formula:

@Prompt([Ok];“Total CG1 Budget”;“Target = 310 FOUPs. Actual = " + @Text(@Count(@DbColumn(“Notes”:“ReCache”;“ef300mmnotes.fishkill.ibm.com”:“300mmProduction.nsf”;“CG1_Monitors”;4))) + " FOUPs”)

This formula counts all the documents included in the CG1_Monitors view and returns the value in a prompt window.

The formula works great using Lotus 6, but does not work using Lotus 5. The following error occurs in Lotus 5 … “invalid formula unknown function / operator.”

Any help would be appreciated. Thank you!

2

Subject: Problem with @Count and @DbColumn

Just check your designer help. you will see there the function @count is new with release 6. so doesnot wrok with lotus 5 or older.

3

Subject: Use @Elements instead!