Hello

I've a problem with formatting. A measure I have can contain both an amount
and a percentage and I'd like to format it as a percentage if the value is
below 1. Can this be done at all??

Thank you

Tore

There's no *nice* way of doing it, but the following query demonstrates how
calculated measures can inherit the formats of other calculated measures,
which might help you do what you want:

WITH
MEMBER MEASURES.PERCENTFORMAT AS 'MEASURES.[UNIT SALES]',
FORMAT_STRING='PERCENT'
MEMBER MEASURES.OTHERFORMAT AS 'MEASURES.[UNIT SALES]', FORMAT_STRING='#,#.00'
MEMBER MEASURES.VARIABLEFORMAT AS 'IIF([Gender].CURRENTMEMBER IS
[Gender].[All Gender].[F], MEASURES.PERCENTFORMAT, MEASURES.OTHERFORMAT)'
SELECT {MEASURES.PERCENTFORMAT, MEASURES.OTHERFORMAT,
MEASURES.VARIABLEFORMAT} ON 0,
[Gender].[Gender].MEMBERS ON 1
FROM SALES

HTH,

Chris


"Tore Johnsen" wrote: