5 Replies Latest reply: Feb 26, 2016 8:55 AM by Yeo Poh sai

# How to Add Rangsum function to my SET expression ?

Hi All

I have below expression , i like to add the expression with RangeSum(Above :-

money(

Sum(

{<Year={'>\$(=year(today())-2)'}>}

\$(ColumnDim51)/\$(Columndim89)/1000)

, \$(vMoneyFormatK))

I have try the below expression , but it does not work :-

money(RangeSum(Above(TOTAL

Sum(

{<Year={'>\$(=year(today())-2)'}>}

\$(ColumnDim51)/\$(Columndim89)/1000, 0, RowNo(TOTAL)))

, \$(vMoneyFormatK))

May i know why ?

In my next posting i will post my QV Doc

Paul

• ###### Re: How to Add Rangsum function to my SET expression ?

My QV Doc

• ###### Re: How to Add Rangsum function to my SET expression ?

Try:

money(RangeSum(Above(TOTAL

Sum(

{<Year={'>\$(=year(today())-2)'}>}

\$(ColumnDim51)/\$(Columndim89)/1000), 0, RowNo(TOTAL))

, \$(vMoneyFormatK)))

• ###### Re: How to Add Rangsum function to my SET expression ?

Hi,

Try this

money(

RangeSum(Above(Sum(

{<Year={'>\$(=year(today())-2)'}>}

\$(ColumnDim51)/\$(Columndim89)/1000)),

Sum(

{<Year={'>\$(=year(today())-2)'}>}

\$(ColumnDim51)/\$(Columndim89)/1000)

, \$(vMoneyFormatK)))

Regards,

jagan.

• ###### Re: How to Add Rangsum function to my SET expression ?

Hi Jagan and Tres

As i learn from Sunny , When he add RangSum to my expression it can help my chart can display Currency sign.

Thank you for your sharing. I try Both your expression into my QC Doc the chart display wrongly.

AS my hope is :-

When i click on S\$

Chart 1 will display

S\$ with sale amount.

Line 1 = 2016 Red color will display jan and feb 2016 sales

Line 2 = 2015 Blue Color will display Jan till Dec sales.

When i Click on Currency = Org

The value above the line will convert the Amount Org currency amount. for example RM\$

My issue now is currency sign is not able to display and decimal point not correct.

Paul

. !

• ###### Re: How to Add Rangsum function to my SET expression ?

Enclosed my QV Doc