Page 1 of 1

Desktop Intelligence

PostPosted: Thu Apr 19, 2012 6:09 am
by lrowley
Hi there, new to the forum.

I have managed to setup a variable that gives me a weighted average of different objects and had added this to a cross-tab query, which works perfectly (tested using a sumproduct formula in Excel). However, when I run the report for a period of more than one month. the additional month name appears at the top but the weighted average is the same across the board. Is there a way to show the different averages for the different months.

Variable: =Sum(((<Advance Value>/(Sum(<Advance Value>) In <var_Concatenate>))*<var_Term>) In (<Contract Number> ,<var_Concatenate>)) In <var_Concatenate>

Many thanks in advance