Advanced Set Analysis - Percent of rows with negative slope

[koscumbs]

Hello all,

I'm trying to show a percentage of patients where the slope of their line (using LINEST_M) is negative.

I'm really struggling with the syntax I need to use for the set analysis -- I believe what I have is somewhat close:

count(

{<PAT_ID = {"$(=LINEST_M(ALL_VL_VALUE,ALL_VL_DATE_DIFF) <0}">}PAT_ID)

          This is the numerator -- it should count the patients (PAT_ID) where the result of the LINEST_M equation is negative

/count(ALL_VL_VALUE)

          This is the denominator -- should be fine the way it is.

In essence, I'm sure my numerator syntax is off, but I have a hell of a time figuring out what I need to do in what order with the dollar sign expansion.  Any and all help would be appreciated.

Thanks!

[sunny_talwar · Accepted solution]

May be misplaced double quote? and an extra dollar sign expansion....

Count({<PAT_ID = {"=LINEST_M(ALL_VL_VALUE,ALL_VL_DATE_DIFF) < 0"}>} PAT_ID)

[koscumbs]

Unfortunately not, that throws me the same error: Error: Error in set modifier ad hoc element list: ',' or ')' expected

[koscumbs]

That edit did it -- I think...stand by.

[koscumbs]

I believe you got it -- thanks for the SUPER fast response!

[sunny_talwar]

Super