Question about CR Graphing

[fe]

I'm graphing on a bunch of data that has some missing fields. These fields show up blank in the legend or at the bottom of the graph. Is there any way I can write a formula that puts something like N/A instead in the graph?

 

[rodbac]

I believe you'll need to graph on a formula instead of the field, and the formula should look something like this:

If {table.graphField} = "" //OR If IsNull({table.field})Then
"N/A"
Else
{table.graphField}

I have not done this before, so my syntax may be haywire, but I believe this will put you on the right track... Let me know if I am way off base! -rodbac

 

[fe]

I tried writing that formula before, but it doesn't work and the graph doesn't change.
Any other suggestions?
Thanks,
Erik

 

[rodbac]

Sorry to beat this up if it's not working for you, but did you try assigning the info to a variable instead? Like this:

Shared StringVar x;
If {table.field} = "" Then
x := "N/A"
Else
x := {table.field};
x

This method is working for me as I type this. If this still does not work for you, post back and we'll figure this out... -rodbac

 

[fe]

When I created this formula, the field doesn't even show up in the Chart Expert/Data Window. Do you know what to do about this?

 

[rodbac]

Whoops! Try declaring the variable as 'Local' instead of 'Shared'... -rodbac

 

[fe]

Sorry - I just found out that the first formula actually works. However, there is still some missing fields, but I think it is due to bad data.
Thanks a lot for your help!