@Sum not adding all values in a view

HCL Domino Domino Forum
1

I have a view which displays one time entry forms. the 2nd column are their hours for each document.

I have another document which pulls up information on how many hours used. The formula for this is:

r := @DBlookup(“”:“NoCache”; “”; “PTOVacation”; @Name([CN]; @Usnername); 2)

value2 := @Sum( r );

The problem is it doesn’t total all documents in the view. Say there are 10 documents, it will only add 9. I tried adding another document and nothing.

I tried searching on the forum for some ideas, tried the view refresh, nothing.

Any thoughts?

Thanks

2

Subject: Don’t you want a dbcolumn?

3

Subject: RE: Don’t you want a dbcolumn?

Well the first column displays the usernames of who created the forms. The 2nd column displays their hour values.

DBColumn would not work for this, since when “user A” opens the form to diaply his stats, I only want to add his own values, not everyones.

Thanks

4

Subject: If you just do the db lookup, can you see which value is missing?

5

Subject: @Sum not adding all values in a view…

have you confirmed that the @dblookup in your formula is only returning 9 documents, and there are definitely 10 categorized under the same @username?

are you positive that whoever the @dblookup is running on behalf of (the current user) has read access to all the documents in question?

6

Subject: Issue resolved…It was the script I had running to save the documents…Thanks for the replies. EOM