Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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), '#%')
i think its to do with your numbering format. Try '##.##%'
regards
Ren
Rikab,
Instead of '#%', try '#0%'
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
Hi,
Do you have any dimension in your gauge chart?
Maybe you need to use the aggr function.
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.
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)
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?
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