calculating index

[#1]

Hi guys,

Trying to calculate an index value of the measures below but for some reason or another not really working? Works perfectly if no dimensions selected, but once i select a value it breaks as below:

Groups	Measurement	measure 1	measure 2
Result 1	268	3,57   %	1,48   %
Result 2	268	12,08   %	5,02   %
Result 3	268	8,20   %	3,40   %
Result 4	268	31,28   %	12,98   %
Result 5	268	8,07   %	3,35   %
Result 6	268,88   %	11,08   %	4,60   %
Result 7	268	15,34   %	6,37   %
Result 8	268	15,84   %	6,57   %
Result 9	268	34,68   %	14,39   %
Result 10	268	11,88   %	4,93   %
Result 11	268	26,53   %	11,01   %
Result 12	268	8,85   %	3,67   %
Result 13	268	4,61   %	1,91   %
Result 14	268	19,03   %	7,90   %
Result 15	268	2,34   %	0,97   %
Result 16	268	39,76   %	16,50   %

My script as follow for "Measurement". Each individually for "measure 1 and 2"

(Count({<flag_has_group={1},flag_third={1} >}DISTINCT id_table1)/
count({<flag_has_group={1},flag_third={1}>}DISTINCT TOTAL id_table1))
/
(Count({<flag_has_group={1}>}DISTINCT id_table2)/
count({1<flag_has_group={1}>}DISTINCT TOTAL id_table2)))*100

[#2]

Markus,

may you share application with data sample.

This will be easier to help if we will be able to look on it.

regards

Darek