Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this:
RangeSum(Above(TOTOAL Sum({<[Generic Drug Indicator] = {'YES'}>}Amount) , 0, 12))
May be this:
RangeSum(Above(TOTOAL Sum({<[Generic Drug Indicator] = {'YES'}>}Amount) , 0, 12))
Many thanks Sunny, most appreciated
Not a problem. I am glad I have been helpful all day today