Desktop Intelligence

Moderators: Snowy, thx4allthefish

Post Reply
lrowley
Posts: 1
Joined: Thu Apr 19, 2012 6:03 am

Desktop Intelligence

Post by lrowley » Thu Apr 19, 2012 6:09 am

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

Post Reply