Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Yoh,
I´ve got that one and without the len function, works good.
if(sum=0,1,sum)
Thanks a lot.
Jorge
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
It is a sum expression, and when the result is 0 it shows that error.
then in that expresion
if(len(expression)<='1',1,expression)
Yoh,
I´ve got that one and without the len function, works good.
if(sum=0,1,sum)
Thanks a lot.
Jorge