cancel
Showing results for 
Search instead for 
Did you mean: 

Creating a flag based formula for Dimension

Former Member
0 Kudos

Greetings everyone,

Hopefully this is simple answer. I have two dimensions "A" and "B" and a measure "C", where "B" is many to one attribute of "A", I would like to create a Flag formula in context that can characterise if a certain attribue of "B" is within "A".

For example:

"A" "B" "C" "MY FLAG"

ABC 123 12.31 Y

BCD 123 10.54 Y

BCD 104 107.83 Y

BCD 105 11.32 Y

DCE 101 11.30 N

DCE 102 11.54 N

DCE 125 12.00 N

Pseudo Formula "MY FLAG" = If ("B" InList ("104";"123") In "A") "Y";"N") - however this formula creates "#multivalue" error.

Would like to use this flag as global indicator for other tables/ reports.

Regards,

Damian

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

What if you try using a max or min function in your formula?

= Max(  If  (<b> InList ("104";"123")  In [A]) "Y";"N")  )   

Does it show the rigth results?

Answers (1)

Answers (1)

Former Member
0 Kudos
=If(Max(If(<b> InList ("104";"123"); 1 ;0)) In ([A])=1;"Y";"N")

Edited by: Me map on Jan 24, 2011 6:58 PM