Condition Problem

[#1]

Hello,

Im currently using some sums if the account balance is on some account that accumulate values.

Currently i use this expression:

RangeSum(Above(SUM({$< Account={'0',

'1',

'2',

'3',

'4',

'6',

'7',

'8',

9',

'10',

'11'}

>} [MXN_Amount BSEG])

,0, RowNo(TOTAL)))

I was wondering if its possible to do something like:

RangeSum(Above(SUM({$< Account >= '1' and Account <= '1000'

>} [MXN_Amount BSEG])

,0, RowNo(TOTAL)))

I havent been able to make this work

Any ideas?, comments?

[MayilVahanan]

Try like this

RangeSum(Above(SUM({<Account  {">= 1 <= 1000">} [MXN_Amount BSEG]),0, RowNo(TOTAL)))

For Set analysis, please refer this

Set Analysis: syntaxes, examples

Its useful to learn abt set analysis

[swuehl · Accepted solution]

Maybe like this

RangeSum(Above(SUM(

{$< Account = {">=1<=1000"} >}

[MXN_Amount BSEG])

,0, RowNo(TOTAL)))