SUM partially working

Mark HHP

I have an object called BookList. Inside this object are three objects named: Regular, Feature and Book Extract. Each of this have a numerical size. BookList also has a field for Size, set to Number. I set the three into a group called Articles and used the following rule.

If BookList.Articles IS DEFINED Then BookList.Size = SUM Articles WHERE (Articles IN BookList.Articles)

Now the strange thing is that its working for some that I had made earlier but not for new BookLists. I can go into the old ones and edit an individual size and it reflects the change. But not in my new ones? Am I going crazy? What would allow it to work on one and not the other? All other elements are identical.

weblike

Waht if you use a "UPDATE Booklist" process?

Mark HHP

I don't think that's the issue. If you make a change to the one, it updates live. But the other object you can save until you're blue in the face and it won't update.

Powerm

You have few options for that:

update every morning using Scheduler
update when a BO is deleted or changed using a Rule
update using a Process which runs every X seconds

Mark HHP

OK my fix was:

changing If BookList.Articles IS DEFINED Then BookList.Size = SUM Articles WHERE (Articles IN BookList.Articles)

BookList.Size = SUM Articles WHERE (Articles IN BookList.Articles)

That seems to do the trick. Strange that it was working previously

Powerm

Correct, sometimes doing the calculation in two steps does not work properly.