Dynamice Expression In Axis Question!

[#1]

Hi guys,

I have a chart on which I would like to have an expression within the 'static min'. I would like it to have a scale where it shows a percentage below the minimum value displayed. So in my expression I tried:

=Sum(Min([$(vOverviweMonthlyUptime)]) - 1.0 [\code]
This just displays the axis at the minimum value and not a percentage below. Even if I changed the numeric figure from 1 to anything esle, it does not change anything. Does anyone know why this is the case?
Thanks in advance



 </body>

[#2]

Try removing SUM() from the expression, you should just need the MIN() part.

If, however, you want to do a minimum of the sum of.......

In this case you should use Min(Aggr(Sum(........ where you aggregate over the dimension(s) you are using in the chart.

[#3]

Hi Nigel,

I did try this without the Sum but again no change:

=min([$(vOverviewMonthlyUptime)]) - 1.0

I also tried the aggr option:

=Min(Sum (Aggr([$(vOverviewMonthlyUptime)]),irMonthYear)-1.0 )

irMonthYear is the only dimnesion I use in this chart.

Neither seem to have worked unfortunately

[#4]

Can you post an example app?