Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
did not get your requirement could you provide more details ..
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.
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)))
Hi Priyantha,
Try this expression:
=SUM({<REMARKS = -{'SET'}>} RangeSum(LOAN_AMT,INT_DUE,-REC_AMOUNT))
Regards!!
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