Error in MDX queries

Dear all Please Help

When I am executing the following queries in MDX the error will come

'Warning 2 Query (15, 1) Parser: The syntax for 'FORMAT_STRING' is incorrect. [Line:15; Column:1] 0 0 '

Query as follows...

CALCULATE;

CREATE MEMBER CURRENTCUBE.[MEASURES].[Percentage of Profit]

AS ([Measures].[Profit],[Sales Analysis].[Group Description].CurrentMember)/([Measures].[Profit],[Sales Analysis].[Group Description].[All]),

FORMAT_STRING = "Percent",

NON_EMPTY_BEHAVIOR = { [Quantity] },

VISIBLE = 1;

CREATE MEMBER CURRENTCUBE.[MEASURES].[Parent Percent]

AS iif(IsEmpty(([Measures].[Profit],[Sales Analysis].[Area Description].Parent)),1,

([Measures].[Profit])/([Measures].[Profit],[Sales Analysis].[Area Description].Parent),

FORMAT_STRING = "Percent",

VISIBLE = 1 ;

hello,

it looks like your second calculated member (i.e. Parent Percent) is missing the closing ')' for the iif function.

hope this helps,