Display 0 in chart when the field value is null 1

[saran26]

Hi All,

I have a field called debugtime in my table. I am displaying that in chart after converting that into a number using a formula

@debugtime

tonumber({ClearQuest.debugtimes})

in the chart , i am displaying Max(@debugtime), if the value is null , I need to display that as Zero in the chart is it possible ?

Please let me know.

Thanks

Saran

 

[saran26]

Hi All,

Let me know if you guys additional details to help me with this request

Thanks
Saran

 

[xicana]

Have you tried using the display string property of that field? You could do something like if isnull(Max(@debugtime)) then '0' else cstr(Max(@debugtime))?? I didn't actually test this, but I use display strings all the time for different reasons.

Sandy

 

[saran26]

Hey,

Thanks for the info. I changed my formula field little bit as follows per your instruction.

if isNull({ClearQuest.debugtimes}) then 0 else tonumber({ClearQuest.debugtimes})


It is working now.

Thanks
Saran

 

[xicana]

That'll do it too!



Sandy