Error in Set Analysis

[#1]

Hello Everybody,

I have used set analysis in my expression for chart.

round(sum({$<WeightedUnweighted.= {'Weighted'},[Probability Group.]={'Open'},Year.= >}RevPreAmount.)/1000000,'0.01')

I am getting an error message when hovering over any of the bar charts.

Is there anything wrong in the expression.

Please find the attached screenshot for the same.

Thanks In Advance

Sonali

[ali_hijazi]

i think you shouldn't put single quotes around 0.01

[#3]

Hi,

Try to use this things

Round(sum({$<[WeightedUnweighted.]= {'Weighted'},[Probability Group.]={'Open'},[Year.]= >}[RevPreAmount.])/1000000,'0.01')

Or

Round(sum({$<[WeightedUnweighted.]= {'Weighted'},[Probability Group.]={'Open'},[Year.]= >}[RevPreAmount.])/1000000,0.01)

Keep the dimensions and measures in brackets.

[#4]

HI Ali,

Removed single quotes still I am getting the same error.

[#5]

HI Rakesh,

Tried both still getting same error

[jyothish8807]

Hi Sonali,

Try without Round an see if output is coming?

sum({<[WeightedUnweighted.]= {'Weighted'},[Probability Group.]={'Open'},[Year.]= >}[RevPreAmount.])/1000000

Regards

KC

[rustyfishbones]

What Dimension are you using?

Could there be an issue with the Dimension or the underlying Data

[Anonymous]

Try using this expr:

Round(sum({$<[WeightedUnweighted.]= {'Weighted'},[Probability Group.]={'Open'},[Year.]= >}[RevPreAmount.])/1000000)

and in the Number Tab:For this expression check the Fixed to option and write '2' in the box provided for the no of digits after the decimal point

[#9]

Hi Alan,

In Dimention I am using the expression:
=if([Effective Date.] >= $(vEffQtr) and [Effective Date.] < $(vEffQtrTill), [Qtr Year.])

where

vEffQtr= Date('01/' &
if( (Ceil(month(MonthEnd(Today())/3)))=1,'01',
    if( (Ceil(month(MonthEnd(Today())/3)))=2,'04',
            if( (Ceil(month(MonthEnd(Today())/3)))=3,'07','10'))) & '/' & year(today()) )

and
vEffQtrTill= AddMonths($(vEffQtr),12)

[rustyfishbones]

your problem is your dimension, however I am not sure what part is the problem

create a text object and add =Round(sum({$<[WeightedUnweighted.]= {'Weighted'},[Probability Group.]={'Open'},[Year.]= >}[RevPreAmount.])/1000000)

Let me know if text objects returns the correct result with no error?

Regards

Alan