Hide Negative values

[NavinReddy]

Hi All,

Could some one help me

How can i hide Negative values in chart ,how can i write expression to hide the negative values

Plz help me to know

Thanks in Advance

Niranjan

[nilesh_gangurde]

SUM(if(VALUE < 0 ,0,VALUE))

this type of condition you can put.

-Nilesh

[#3]

Try if(YourField > 0, YourField)

[Clever_Anjos]

rangemin(yourfield,0)

[NavinReddy]

Hi Nilesh,

And i need to make it negative values positive

Regards

Niranjan

[Clever_Anjos]

fabs(yourvalue) if you want negative as positives

[nilesh_gangurde]

Use Fabs Function.

Sum(Fabs(FieldName))

-Nilesh

[kiranmanoharrode]

Hello Niru,

Use Fabs() function which converts all numeric values to Positive.

Regards

Kiran Rode

+91 8976977897

[aolaleye]

Hi All: I used the RangeMax function. RangeMax(Value,0) and it worked. Thanks for all the suggestions.

[Surya]

if u want Hide 

If(fieldname > 0,fieldname)

if u want convert negative into positive use

fabs(fieldname)