Limit contents of Straight Table based on multiple 'Or' conditions

[#1]

Hi All,

I am looking to customise a table of projects based on multiple 'Or' conditions. For example, the table should include any projects that are Active or IT orcost over €xx or have open issues or have a budget overrun etc.

I have been using 'If' statements (as Calculated Dimensions) to check one or two conditions and return a value if positive or a null if negative. To limit the false results I have been using the checkbox 'Suppress When Value Is Null'.

This has been working ok to date, however some new conditions have now been added which is causing the error:

"OUT OF VIRTUAL AND/OR LOGICAL MEMORY, allocating 2MB"

The conditions that I am checking reside in multiple tables, so I do not think that I can do this in the script.

Is there a smarter way to do this that is less taxing on the system?

Many thanks,

A

[Gysbert_Wassenaar]

There very likely is. But without looking at the document it's next to impossible to tell how.  Please read this document: Preparing examples for Upload - Reduction and Data Scrambling