Trend line in chart report

[johny.cbi]

Trend line in chart report

for trend line we have the report expression in cognos support (pdf)

((total(minimum([X]*[Y] for [X]) for report)-total(minimum(1 for [X]) for report)*
average(minimum([X] for [X]) for report)*average(total([Y] for [X]) for report))*[X]
+ (average(total([Y] for [X]) for report)*total(minimum([X]*[X] for [X]) for report)
-average(minimum([X] for [X]) for report)*total(minimum([X]*[Y] for [X]) for report)
))/(total(minimum([X]*[X] for [X]) for report)-total(minimum(1 for [X]) for report)
*average( minimum([X] for [X]) for report )*average( minimum([X] for [X]) for report ))

that is working for some chart reports

my question is  I have measure sales amount and on X-Axis I've Year

while trying with the above expression the sales amount is showing wrong

please share your ideas about trend line for the graph 


Thanks

[RainerF]

Hi Johny,

it's a long time ago, but: Have you found a solution?

Regards, Rainer