Hi there

U can also create a var @ActionTable TABLE(id INT IDENTITY(1,1),Action VARCHAR(20))

insert the possible actions into this table

INSERT INTO @ActionTable (id,Action)

SELECT 'NEW'

UNION ALL

SELECT 'DELETE'

UNION ALL

...

or better u could...

Hi there.

U probably solved the problem already. But here it goes:

If u have a distinct count of employees u can do this:

Aggregate([employees].[ALL],[Measures].[sum bonus value]) /

aggregate([Status].[Active],[Measures].[distinct count of employees])

If u...