8 Replies Latest reply: Feb 17, 2016 11:06 PM by Yeo Poh sai

Hi Sunny

I have one more expression need to add above(range ,

money(

sum({\$<year = {\$(=max(year)-1)}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}>}\$(ColumnDim51)/\$(Columndim89)/1000)

, \$(vMoneyFormatK))

I have try below exrepssion but it does not work :-

Money

(RangeSum(Above

(TOTAL Sum(DISTINCT

{\$<year = {\$(=max(year)-1)}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}>}\$(ColumnDim51)/\$(Columndim89)/1000)

, 0, RowNo(TOTAL)

))

, \$(vMoneyFormatK))

Paul

• ###### Re: How to add set expression with add (RangeSum(Above ?

Enclosed my Sample QV Doc

• ###### Re: How to add set expression with add (RangeSum(Above ?

Hi,

Try this expression

money(

RangeSum(Above(TOTAL sum({\$<year = {\$(=max(year)-1)}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}>}\$(ColumnDim51)/\$(Columndim89)/1000)),

sum({\$<year = {\$(=max(year)-1)}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}>}\$(ColumnDim51)/\$(Columndim89)/1000))

, \$(vMoneyFormatK))

• ###### Re: How to add set expression with add (RangeSum(Above ?

Hi Jagan

Cannot work.

Paul

• ###### Re: How to add set expression with add (RangeSum(Above ?

Try this

money(

RangeSum(Above(TOTAL sum({\$<year = {\$(=max(year)-1)}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}>}\$(ColumnDim51)/\$(Columndim89)/1000), 0, RowNo(TOTAL)))

, \$(vMoneyFormatK))

Regards,

Jagan.

• ###### Re: How to add set expression with add (RangeSum(Above ?

Hi All

Thank you very much both sunny and Jagan , it work fine now.

Paul

• ###### Re: How to add set expression with add (RangeSum(Above ?

May be this:

Money(

RangeSum(Above(sum({\$<year = {\$(=max(year)-1)}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}>}\$(ColumnDim51)/\$(Columndim89)/1000), 0, RowNo()))

, \$(vMoneyFormatK))