Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
SUM(if(VALUE < 0 ,0,VALUE))
this type of condition you can put.
-Nilesh
Try if(YourField > 0, YourField)
rangemin(yourfield,0)
Hi Nilesh,
And i need to make it negative values positive
Regards
Niranjan
fabs(yourvalue) if you want negative as positives
Use Fabs Function.
Sum(Fabs(FieldName))
-Nilesh
Hello Niru,
Use Fabs() function which converts all numeric values to Positive.
Regards
Kiran Rode
+91 8976977897
Hi All: I used the RangeMax function. RangeMax(Value,0) and it worked. Thanks for all the suggestions.
if u want Hide
If(fieldname > 0,fieldname)
if u want convert negative into positive use
fabs(fieldname)