simple BO question - changing 1 to display as N 1

[smooveb]

Hi,

I'm trying to create a variable from the reporting side that will take a numerical value of 1 and display N, 0 and display Y. Sure there's a simple way using the Variable editor, but I'm a little clueless.

Thanks in advance!
Barrett

 

[skrandel]

=if (<variable> = 1) then &quot;N&quot; else &quot;Y&quot;

Or you could use an alert. Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com

 

[smooveb]

Thanks - realize now that I can use an alerter, but would still love to get it to work using that formula.

lets call my variable N Normal Ind, and it is a measure. I'm defining a new variable as a dimension with the following formula:

=IF (<N Normal Ind>=&quot;1&quot then &quot;N&quot; else &quot;Y&quot;

message it's throwing at me is 'Incorrect Data Type'. This happens if I define the new variable as a measure as well.

Any ideas? Could this have something to do with the back end or universe construction?
Thanks, Barrett

 

[smooveb]

sorry, my fault - putting &quot; &quot; around the 1 was silly

B