using two fields for Value Expressions?

[ericlomm]

Hello,

I am working on a report that I would like to have include a Barchart. An approximate example of the data I am reporting on is:

Clinc,VisitID,Decline,Improvement
1       ,         1,              ,
1       ,         2,     -0.08,           0.11
1       ,         3,     -0.09,           0.12
1       ,         4,     -0.05,           0.10
1       ,         5,     -0.03,           0.06
1       ,         6,     -0.05,           0.10
 

I am setting the series expression to Clinc. The Category expression is the VisitID. What I want to have in the value expression is both the Decline and the improvement values. However when I try to put both of these values in as value expression I am getting an error evaluating the expression.

The expression I am trying to ues is shown in the code. I have included a sample that shows what I am looking for.

How would I write the value expression to get the results I am looking for?

Thanks in advance

Eric Lommatsch

 

Code:

$F(Decline)$F(Improvement)