Counting differences between rows

[camoesjo]

Hi

I have two alarms that display dots in a chart if certain conditions are met.

if (isnull(var_x) and [date]<=today(),11)
if (fabs(var_x-Above(var_x))>2.5 ,11.5)

Counting the total number of alarms works for the first one:
count(DISTINCT if([var_x]>10 or [var_x]<=0, [date]&'-'&[name]))

But it doesn't work for the second one:
count(DISTINCT if (fabs([var_x]-Above([var_x]))>2.5 , [date]&'-'&[name]))

(it returns a "Allocated memory exceeded" error).

Suggestions? Thanks!

[Brett_Bleess]

Jorge, you are likely going to have to attach the QVW on this one for someone to be able to try to give you some guidance.  In these cases, folks generally need to see the data model as well as the context of the expression etc...

What I can tell you is the message you are getting indicates the calculation is taking up a lot of resources, which would lead me to believe that it is creating some sort of Cartesian product etc., and again, this is where folks will need to see your data model etc. in order to try to figure out what is going on.  

Regards,
Brett