Change error text...No numeric values on x axis

[#1]

Hi, when making a selection the chart defaults to a warning of No numeric values on x axis. I would like to change this to something more accurate like No budget available but when I go to Properties->Error Messages and change Default it doesn't change this error message.

Any ideas?

[danieloberbilli]

I think this kind of error needs to be solved in the expression itself. Could you please post your chart expression?

[#3]

Hi there, quick reply

=IF(ISNULL(SUM(Budget)),0,SUM(Budget))

The ISNULL is intended to ensure the graph keeps displaying if there is no data and intent was then to display a warning to the user through the error message functionality.

[danieloberbilli · Accepted solution]

I might be wrong, but I think you cant handle this with the standard error messages. As far as I understand the standard error messages, they only cover object-specific/controlled issues e.g. is an object-condition fulfilled or not.

But your condition is based within an expression and based on your actual data (and not on the object).

As a workaround I would suggest to show/hide a textbox with the error message as a layer above your chart with a condition...so it can hide your chart and show the error message.

[hariprasadqv]

Hi,

If your app is not having any custom error messages other than the one which you specified here,then you can replace all the error message with your wish in the Default mode of custom error messages.

[sasikanth]

HI,

Try Like this ,

take one text Object and Enable it when ever budget is null

like if(SUM(BUDGET)=0,1,0)

change layout option from Bottom to Top and write the text you want

[#7]

Yep tried the custom error message but no luck Another overlapping text box should work

[#8]

Ok, great idea on the chart box.

I fiddled a little and found by setting a calc condition of

=IF(SUM(Budget)=0,0,1)

Then putting the error message text as the text I wanted it finally showed the way I wanted it to!