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)

to

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.