Post reply

Directional indicators part two

  • October 8, 2014 at 4:51 am

    #290645

    Hello

    I have a report which shows month in one column and value in the next, eg:

    Jan 200

    Feb 250

    March 300

    I want to use directional indicators to show if a value is higher or lower than the previous month's.

    I have created a new column and inserted an indicator, then selected directional. I then right-click on the indicator and select Value and States. In value I have chosen the field (monthly sales); states I've set as numeric and I've got rid of the amber icon.

    I have tried various expressions with the 'start' and 'end' vales for the down (red) and up (green) arrows, but to no avail. What I want to do is seemingly quite simple, yet I can't crack it.

    Does anyone have any suggestions as to what expression I should use to get this to work? Thanks.

  • October 8, 2014 at 9:07 am

    #1751018

    Try the below:

    For the values and states

    Up Arrow Indicator

    Start = 1 End = 1

    Down Arrow Indicator

    Start = 2 End = 2

    Some other indicator to capture where they are the same and others

    Start = 3 End = 3

    The indicator state the following expression should do the trick (Changed for your fields and you would also need to amend to take into account the first value does not have a previous value.

    =iif(Fields!PopulationTotal.Value > Previous(Fields!PopulationTotal.Value),1,iif(Fields!PopulationTotal.Value < previous(Fields!PopulationTotal.Value),2,3))

    http://msdn.microsoft.com/en-us/library/dd255200.aspx

  • October 8, 2014 at 9:30 am

    #1751026

    Thanks very much for getting back. Your suggestion makes perfect logical sense and I'm sure will work, but:

    I put the expression you suggested (amended with my fields) into the Value field, ran it, and got a message stating (in summary) 'that the value expression ...has a scope parameter that is not valid for an aggregate function.'

    In the expression you suggested, should I be putting "Dataset 1" in there somewhere?

    Thanks.

  • October 8, 2014 at 9:32 am

    #1751028

    Worth a shot to try that or reference the text box with the value directly. Without the actual report and data set it's difficult.

  • October 8, 2014 at 12:40 pm

    #1751083

    I managed to fix it and it works perfectly now: without your help this would not have been possible.

    Many thanks.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply