Summary Item override

3.78K viewsFormulas and Functions
0
0 Comments

Dear Quantrix Users,

Using summary items in a matrix it seems to me that they have absolute eclipsing priority. That means another formula for a particular cell which is evaluated by a summary item will be ignored.

Did I miss something, or is there any way to get round this?

Regards,
– Raoul

3 Answers

0
quantrix qa3.18K 0 Comments

Hello Raoul – Thanks for your post.

You are correct in your observation that Summary Item formulas have absolute eclipsing priority.

A way around this is to create an item that will contain the summary in the matrix then write the formula using the sum(summary) statement. Doing it this way allows you to use the appropriate SKIP and IF statements to resolve the eclipses in the Matrix.

Attached to this post is a Quantrix Model file showing the difference between the two approaches.

A question for the Quantrix Users… Should the automatic summary items rules be relaxed? That is, should we allow the user control over how the automatic summary items eclipse other formulas?

Post your thoughts on this thread for consideration!

Thanks,

-Mike

Attachments

summaryitems.model
You are viewing 1 out of 3 answers, click here to view all answers.
1049 Questions total questions asked
83 Solved total solved questions
2611 Answers total answer posted
12659 Total users total community members