2 Replies Latest reply: Mar 17, 2011 7:33 AM by Wentworth1 RSS

    How to display the expression of an expression

    Wentworth1

      Hi,

      I need to work out how to build an expression which works out the average values over a period of time and then counts that number of these which are over target and the number which are below target. I was looking to build this in a gauge chart but I'm not fussy if this is not possible. I guess the crux of it is how do you structure an expression so that the later part calculates based on the results of the earlier part?

      Please, can anyone help me?!

      Thanks,

      Rachel