Multibox ( Positive and negative)

[#1]

Hi, i need help for this:

I have this table, and i need to create a multibox, with 2 values ( 1. Selecting the posives ,2. Selecting the negatives)

Is this posible?

	Num	Num PY	Delta	Delta Pax %
a	685	738	-53	-7,2%
b	364	347	17	4,9%
c	253	302	-49	-16,2%
d	234	224	10	4,5%
e	196	153	43	28,1%
f	157	107	50	46,7%
Total	2.490	2.567	-77	-3,0%

Thanks

[giakoum]

yes if you create an expression :

[#3]

Hi,

You can put two expressions in different Mutli-box's like

If delta < 0 for negative values

and

If delta >0 for positive values

Regards,

KC

[morganaaron]

If you want it as one selection, create an expression as suggested and write:

If(Delta >= 0, 'Positive', 'Negative')

Which should give one selection of either positive or negative that will filter your delta values.

If you want them as separate drop down selections, you could have the actual values by writing:

If(Delta >= 0, Delta) and If(Delta<0, Delta) as two expressions.

[#5]

The problem is that this table box has a Dimension, so if i put in a separte object the multibox as positive and negative, this does not work

Thanks

[morganaaron]

A table box is a complete list of all data related to the fields you enter, so this shouldn't stop it from working.

Even if you had a straight table chart and had a dimension, it would still work. What's the exact problem you're facing? Can you post an example? Because any of the options above should work unless your delta field isn't an actual field and is a calculation of another value?