This website is not affiliated with, sponsored by, or approved by SAP AG.

Desktop Intelligence

Moderators: Snowy, thx4allthefish

Desktop Intelligence

Postby 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
lrowley
 
Posts: 1
Joined: Thu Apr 19, 2012 6:03 am

Return to SAP Business Objects

Who is online

Users browsing this forum: No registered users and 2 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.