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
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