How To Guess That A Cell Represents A Total (or A Subtotal)

osendej

Bonjour à tous !

I'm evaluating FastCube
and trying to guess how to recognize a total
(or subtotal) cell.

In the formula editor for a calculated measure,
I did something like the following :

---

var
n : integer ;

begin
Measures.PrepareDetailInfo ;
n := Measures.RecordCount ;
if ( n = 1 ) then // the cell is "probably" a total if any

end

---

As expected, it takes a while because of "Measures.PrepareDetailInfo" !!!
Could you please teach me a better solution ?

Thank you.

Joseph

PS. I can read Russian

-=oleg=-

Hi.
Excuse for a delay with the answer.

I will add this property in script in next update.

Now You can test Dimensions.Items[ADimensionIndex].Caption for string 'Total'.

Oleg.

osendej

написал: »

Hi.
Excuse for a delay with the answer.

I will add this property in script in next update.

Now You can test Dimensions.Items[ADimensionIndex].Caption for string 'Total'.

Oleg.

Thank you very much