Mini chart error message.

[#1]

Hi there,

Could somenone help? I have a straight table with a cyclic group of dimensions and on the expression, I have a linear gauge chart showing sum result for these dimension.

The question is; How can I not display on the straigh table expression chart column the error message showing on the file I have attached here, when I dont have values for my sum?

Kind regards,

Jorge

[Anonymous]

the vaule of limits in the guague setting are bad ..so that is the reasons that error msg is popping up ..can you post a sample file so that i can look at the expression used and solve your problem

[#3]

It is a sum expression, and when the result is 0 it shows that error.

[Anonymous]

then in that expresion

if(len(expression)<='1',1,expression)

[#5 · Accepted solution]

Yoh,

I´ve got that one and without the len function, works good.

if(sum=0,1,sum)

Thanks a lot.

Jorge