Hi @dgambin,

I have got the same problem for sum and avg. Did you find any solution for this? If yes can you please let me know how you have done this case. Thanks very much on any help.

I will be very helpful if you have any material as am new to mondrian stuff.

Thanks....Sai...

** Semi additive problem**

Hi,

I am trying to calculate the "balance" measure that should be summed across all dimensions except time. Time dimension has months and days and the value for the month should be the average of balances across days.

The problem is, for example: I have several accounts. The balances across the accounts should be summed but they are averaged instead. So I must be doing some stupid mistake. I have tried defining the calculated measure as follows:

<Measure name="StanjeSum" column="stanjekn" visible="false" aggregator="sum" formatString="#,##0; -#,##0"/>

<Measure name="StanjeAvg" column="stanjekn" visible="false" aggregator="avg" formatString="#,##0; -#,##0"/>

<CalculatedMember name="Stanje" caption="STANJE" dimension="Measures">

<Formula>CASE WHEN [Period].Level IS [Period].[Months] THEN [Measures].[StanjeAvg].Value ELSE [Measures].[StanjeSum].Value END</Formula>

<CalculatedMemberProperty name="FORMAT_STRING" value="#,##0; -#,##0"/>

</CalculatedMember>

This is not it, right? I have tried with the following too:

<Formula>CASE WHEN ([Period].Level IS [Period].[Months]) THEN AVG(DESCENDANTS([Period].CurrentMember,[Period].[Days]),[Measures].[StanjeSum].Value) ELSE [Measures].[StanjeSum].Value END</Formula>

but the result is the same...

Where am I wrong?

thanks very much on any help

regards, dejan