Expression Syntax

[Anonymous]

I am trying to limit my expression to a particular situation as follows:

  RangeSum(Above(total Sum(Amount) , 0, 12), [Generic Drug Indicator] = 'YES')

This does not filter the results with the 'Generic Drug Indicator' with the value remaining the same without this.  Can you kindly suggest the correct syntax for this expression.

Regards.

[sunny_talwar · Accepted solution]

May be this:

RangeSum(Above(TOTOAL Sum({<[Generic Drug Indicator] = {'YES'}>}Amount) , 0, 12))

[Anonymous]

Many thanks Sunny, most appreciated

[sunny_talwar]

Not a problem. I am glad I have been helpful all day today