Calculated Measures totals and subtotals.

[bobibp]

Hi

We have a little problem in the calculation method of totals and subtotals of calculated measures. At present they are being calculated by the formula set in the calculated measure in compliance with the corresponding totals. We want these totals and subtotals to be calculated in the regular way - as sums of their subelements. Is it possible?
Have a nice day!

[AlexZencovich]

No. All cells calulated by single formula. You asked for different formula for different cells. You may do that by setting event handler to OnGetCellValue event.

If you need to get sum of values above - try to get RunningTotalByColumn/Row value instead of just Value. RT calulated as sum of subcells.

[snoopy_spy]

Hello

I need this too, i don't know how to handle this

i have a simple Calculation

Code: Select all

Result := "NETTO"+10

to add to every record for example 10
the result now is

Code: Select all

NETTO CALC
Customer1 5         15
Customer2 7         17
Customer3 9         19
Sum           21       31

how can i handle this?

[AlexZencovich]

Hello

I need this too, i don't know how to handle this

i have a simple Calculation

Code: Select all

Result := "NETTO"+10

to add to every record for example 10
the result now is

Code: Select all

NETTO CALC
Customer1 5         15
Customer2 7         17
Customer3 9         19
Sum           21       31

how can i handle this?

I can only suggest to perform a custom function which will return a number of nested rows (func cnt();)
and use it like
Result = Value + Cnt()*10;

[snoopy_spy]

Ok it was just an example
but in this simple example, i get problems with this function or?

Is there no other possibility to get the sum working?

we have for example a function

Result := MAX("NETTO1"-"NETTO2", 0)

MAX is a customer function

i don't know how i can make it that our customer is satisfied ...