How to compare a string value measure with constant 
Author Message
 How to compare a string value measure with constant

Hi everybody
In AS 2000, I want to create a new calculated member CaMem that depend on a specific value "string value" of a string value measure Mea :
IIF(Mea = "string value", ... , ...)
But AS can't do this test: Mea = "string value"
Any solution???
thank you

*** Sent via Developersdex http://www.***.com/ ***
Don't just participate in USENET...get rewarded for it!



Fri, 07 May 2004 16:50:14 GMT
 How to compare a string value measure with constant

Surprising but true!

Use

iif (CStr (Mea) = "string value", ..., ...)

HTH

Quote:

> Hi everybody
> In AS 2000, I want to create a new calculated member CaMem that depend on a specific value "string value" of a string value measure Mea :
> IIF(Mea = "string value", ... , ...)
> But AS can't do this test: Mea = "string value"
> Any solution???
> thank you

> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

--
George Spofford
Microsoft MVP
Chief Architect / OLAP Solution Provider
DSS Lab



Fri, 07 May 2004 20:35:10 GMT
 How to compare a string value measure with constant
Thanks George!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Sat, 08 May 2004 21:23:10 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Comparing a Bit value against a String Value

2. Calculated Measures - How to compare cell values

3. Char with ASCII value 0 causes unterminated string constant

4. Using the value of a measure that returns a string

5. String Value Measure

6. Using string values in measures

7. Comparing datetime field (containing date, time values) to a date only string

8. Problem comparing string values

9. Invalid Default Measure Value when changing Measure Name

10. Problems comparing string to integer value.

11. Comparing string values in DTS package

12. compare String with database values


 
Powered by phpBB® Forum Software