Conditional

[#1]

Hi,

I need some help with conditional. Let say i have a table that i got from script that looks like this

Number    Value

5250         100,00

5450         150,00

6550         200,00

6670         200,00

If i create a CHART that uses number and value how to limit that chart to only show values that contain certain number or group of numbers. Example, how to only show 5250 (nothing else), or how to show all that start on 5%.

Thanks in advance.

[Gysbert_Wassenaar]

If you want to show only the values of number 5250 the easiest way is to add a listbox for the Number field and then select 5250 in that listbox. If you want the hardcode that value in the table you can try using Number as dimension and as expression sum({<Number={5250}>}Value).

[cesaraccardi · Accepted solution]

Hi,

That's quite simple, for example if you create a chart using "Number" as a dimension and an expression like: sum({$<Number={5250}>} Value)

If you want to show all that start with 5:

sum({$<Number={'5*'}>} Value)

Regards,

Cesar