on 01-22-2011 12:11 AM
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
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
=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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.