How do I write a Formula using a Variable in my table in BO 5.1

[Jason191]

i am trying to write a logical statement saying if Revenue is from 2003 put in column one, if Revenue is from 2004 put in this column. Is there any way to write a formula that incorporates field from my selected universe, but are not in my table.

 

[skrandel]

Nope. This is not possible. If you are going to use "If" with dimension, then the dimension must exist in the block.

A better way to do this is to do it at the universe level and use a CASE or decode to bucket the data the way you want.

Another option is to use a different object. If you Year is not set as a dimension, you may be able to do what you want. You can also try including the dimension in your table, but then hiding it.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[skrandel]

Wait, I think you can use the Where operator to get what you want.

In one column put <Revenue> where (<Year>="2003")

In the other......

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[blom0344]

Sorry to butt in, but wouldn't this be a qualifier for a crosstab instead of a table? (with <year> in the header)

T. Blom
Information analyst
tbl@shimano-eu.com

 

[skrandel]

Too funny! I was trying to answer the question instead of solving the probem. Good catch Blom.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com