Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You could just input some static label for the dimension on the Dimensions tab of chart properties. It seems QV trying to use that calculated dimension formula as the label is the only problem, after all the dimension values themselves on that axis seem fine.
i think you shouldn't put single quotes around 0.01
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.
HI Ali,
Removed single quotes still I am getting the same error.
HI Rakesh,
Tried both still getting same error
Hi Sonali,
Try without Round an see if output is coming?
sum({<[WeightedUnweighted.]= {'Weighted'},[Probability Group.]={'Open'},[Year.]= >}[RevPreAmount.])/1000000
Regards
KC
What Dimension are you using?
Could there be an issue with the Dimension or the underlying Data
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
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)
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