Display Only Negative values

[Anonymous]

hello Guys,

Could you please help me with the following questions :-

I have a field with both positive and negative values.

I want to display all negative values in the Data Sheet .

Something like this as shown below :-

Interval
-1
-3
-4

Thanks in Advance,

Ravi

[sunny_talwar]

May be like this,

RangeMin(ExpressionOrFieldName, 0)

[Anil_Babu_Samineni]

May be this?

If(Sum(Interval) <0, Interval)

OR

Sum({<Interval = {'<0'}>} Interval)

[Anonymous]

Thanks for your reply Guys,

I donnt need to do any sum or any aggregation function .

I just need create a new column in data sheet with only negative values (without null values)

I am using this as dimension  expression which I need for data sheet

If (Interval<0,(Interval))   this expression works for me but shows null values too.

how to get rid of null values using above expression .

Thanks,

ravi

[sunny_talwar]

May be check 'Suppress When Value Is Null' on the dimension tab of chart properties

[Anonymous]

Ok ! Thanks will try !