Help with Window Title in Gauge Chart!

[#1]

Hi All,

I am using the below expression in gauge chart. The result are getting displayed in the in proper format. Could you please tell me what exactly I need to do so that it displays the result in correct format.

====date(makedate(Max(Year), Max(Month)), 'MMM YYYY') &' vs ' & date(makedate(Max(Year), Max(Month-1)), 'MMM YYYY')& ' Sales Growth @ ' & num(Sum({$<Year={$(=Max(Year))},Month={$(=Max(Month))}>} SalValue) / Sum({$<Year={$(=Max(Year))},Month={$(=Max(Month)-1)}>} SalValue), '#%')

[renjithpl]

i think its to do with your numbering format. Try '##.##%'

regards

Ren

[Anonymous]

Rikab,
Instead of '#%', try '#0%'

[#4]

Hi All,

I already tried both the method but it shows different value. Explained it in the below screen shot.

[renjithpl]

Hi Rikab,

Can you send the data which you are getting when you do your below code.

1. Sum({$<Year={$(=Max(Year))},Month={$(=Max(Month))}>} SalValue) ????

and

2. Sum({$<Year={$(=Max(Year))},Month={$(=Max(Month)-1)}>} SalValue) ????

Regards

Ranjit

[#6]

Hi,

Do you have any dimension in your gauge chart?

Maybe you need to use the aggr function.

[#7]

Eduardo Correa wrote:
Do you have any dimension in your gauge chart?
Maybe you need to use the aggr function. <div></div>

Yes, Dimension is there.

[#8]

Hi Ranjit,

This is what I am using in the expression. mfacname is there in the dimension.

Sum({$<Year={$(=Max(Year))}>} SalValue) / Sum({$<Year={$(=Max(Year)-1)}>} SalValue)

[#9]

I think that the result "10.xxxxxx" are a partial result because you have a dimension in your chart.

How in the title don't have dimension group by the function AGGR the result are "28%".

If you change your chart to straight table, how many rows return?

[renjithpl]

I meant, the values you are getting seperately

1. Sum({$<Year={$(=Max(Year))}>} SalValue)

2. Sum({$<Year={$(=Max(Year)-1)}>} SalValue)

Normally when i get such errors, i calculate the values in a normal calculator, and analyse where the changes need to be done. sometimes, it accepts *100 or /100 will give the right answer.

I am not sure, but i will try definetly. 🙂

Regards