Simple expression

[#1]

Dear Experts,

My expression is shown below,

IF(REMARKS='SET',0,RANGESUM(LOAN_AMT+INT_DUE-REC_AMOUNT))

Expected results can be achieved with this expression other than grand totals.

Please help me to find the alteration required.

Rgds,

Priyantha.

[avinashelite]

did not get your requirement could you provide more details ..

[#3]

as i think i have omitted "SUM" or "AGGR" part from this expression. still i couldn't find which part to where i should insert.

Thanks Avinash for early reply.

Priyantha.

[Anil_Babu_Samineni]

Share the screen shot where you get the issue and although try this

IF(REMARKS='SET',0,RANGESUM(LOAN_AMT,Interval(INT_DUE-REC_AMOUNT)))

OR

IF(REMARKS='SET',0,RANGESUM(LOAN_AMT,(INT_DUE-REC_AMOUNT)))

[Anonymous]

Hi Priyantha,

Try this expression:

=SUM({<REMARKS = -{'SET'}>} RangeSum(LOAN_AMT,INT_DUE,-REC_AMOUNT))

Regards!!

[sunny_talwar]

To more closely mimic the if statement, I would put the negative sign before the equal sign

=Sum({<REMARKS -= {'SET'}>} RangeSum(LOAN_AMT,INT_DUE,-REC_AMOUNT))

or another option is to use Sum(Aggr())

Sum(Aggr(If(REMARKS='SET', 0, RangeSum(LOAN_AMT+INT_DUE-REC_AMOUNT)), ChartDimensionsHere))

Here make sure to replace ChartDimensionsHere with the dimensions from your chart