
Re: Line chart 2 expressions in 1 line
ioannis giakoumakis Dec 17, 2012 6:32 AM (in response to Nikolaos Kavroulakis)You can actually add the two expressions into one, just take care of the null values. if you dimension is time though, you could end with a gap. For example, if expr1 is up to 2012P11, and exp2 for 2012P12 and over, there will be a gap in the line.
If you could give more details, I could be of better help.

Re: Line chart 2 expressions in 1 line
Nikolaos Kavroulakis Dec 17, 2012 6:42 AM (in response to ioannis giakoumakis )Se euxaristw gianni gia ton xrono sou kai thn bohtheia sou.
What i actually have is a Quantities comparison graph by time. Where i have 3 plot lines one for Actual Quant,one for Forecast Quant and one for Budget Quant. The data will contain no null values so there is no consistency problem.
How can I manage to fit two expressions in one as you said i have not figured it out. I have sum(Actual.Quant) and
sum(Budget.Quant) as my expressions.
Re: Line chart 2 expressions in 1 line
ioannis giakoumakis Dec 17, 2012 6:53 AM (in response to Nikolaos Kavroulakis)I would combine the 2 expressions into one :
if(isnull(sum(Actual.Quant),0,sum(Actual.Quant)) + if(isnull(sum(Budget.Quant),0,sum(Budget.Quant))
checking for null so that the result will not be null when either part of the expression is null.
Ότι χρειαστείς στην διάθεση σου!

Re: Line chart 2 expressions in 1 line
Nikolaos Kavroulakis Dec 17, 2012 9:33 AM (in response to ioannis giakoumakis )Thanks very much for the answer and your time giannis.You proposed solution works pretty well but I used the following expression =if(b.Month<Num(Month(Today())),sum(Actual.Quant),sum(Budget.Quant)) in order to do this in a more sophisticated way .


