Showing Total Average figure only - ReportNet -

[Draoued]

I have the following table

Load Drop KG
A 2 30
A 3 50
B 1 10
C 1 10

Average Kg per count(drop) = 100 / 4 = 25
That s fine I managed to calculate that

My problem is : I need to display only 25 in the report, not the whole list nor the list header.
Something like :
'the average is 25 kg per Drop'
When I calculate it in the list , and then move it to a repeater or a block , it is showing the Average for the First Row and not the list average.
Any Idea how to display only the summary average ??
thanks

 

[Draoued]

I found a solution not very nice but working.
Changing Box type to none , to hide all un-necessary cells.

 

[ChillAPAC]

Your query needs to return only the summary row.
How about something like:
Query1
SELECT sum(Kg)/count(Drop)
FROM Table

 

[Draoued]

Thanks ChillAPAC.
But I don't want to go to plain SQL , as it is more difficult to maintain afterwards.

 

[drewdaman]

there is a roll up property somewhere in FM. set that to avg (instead of sum) and publish the package.. then when you just put the kg thing in your report, it shoudl find hte average.

 

[JGirl]

Do you intend to only publish the average value via FM, or are you going to publish the load, drop, and KG columns?

Assuming you publish three columns, load, drop and KG to reportnet for use in ReportStudio, you could create a report that has a query in it called Query1. Inside this Query1, have a tabular model.

In the query, create a calculation called 'AverageKilos'
derivation = [totalweight]/[totaldrops]

In the tabular model:
* create a data item called 'totalweight'
Derivation = total([x].[x].[KG] for Report)
* create a data item called 'totaldrops'
Derivation = count([x].[x].[drop] for Report)

Then no matter where in the report you embed this query item, the rollups will be maintained for the report.

J

 

[Draoued]

Drewdaman : You can also change the property in reportnet studio to be at data item , but this doesn't work the way I way.

Jgril: I m publishing only the average Kg figure, this is not going to work , as it was how I tried to do it.
But as soon as I drag only the summary figure, the content is changing.

Thanks for the input anyway.